Test query d
{{#visualdataquery:[[name::Afghanistan]] [[states/name::Badakhshan]]
|schema=Country
|?states/cities/name
|?states/cities/latitude
|?states/cities/longitude
|format=datatable
}}
SELECT t0.page_id AS `page_id`,t2.value AS `v2`,t3.value AS `v3`,t4.value AS `v4` FROM (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'name' ) `t0` LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/name' ) `t1` ON (((t1.page_id=t0.page_id))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/name' ) `t2` ON (((t2.page_id=t0.page_id) AND (LOCATE( t1.path_parent, t2.path_parent ) = 1))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_numeric` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/latitude' ) `t3` ON (((t3.page_id=t0.page_id) AND (t3.path_parent = t2.path_parent))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_numeric` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/longitude' ) `t4` ON (((t4.page_id=t0.page_id) AND (t4.path_parent = t2.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE ((t0.value = 'Afghanistan')) AND ((t1.value = 'Badakhshan')) LIMIT 100
{{#visualdataquery:[[name::Afghanistan]] [[states/name::Badakhshan]] [[states/cities/name::A~]][[states/cities/latitude::36.68333000]] [[states/cities/restaurants/name::bbb]]
|schema=Country
|?states/cities/name
|?states/cities/latitude
|format=datatable
}}
SELECT t0.page_id AS `page_id`,t2.value AS `v2`,t3.value AS `v3` FROM (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'name' ) `t0` LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/name' ) `t1` ON (((t1.page_id=t0.page_id))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/name' ) `t2` ON (((t2.page_id=t0.page_id) AND (LOCATE( t1.path_parent, t2.path_parent ) = 1))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_numeric` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/latitude' ) `t3` ON (((t3.page_id=t0.page_id) AND (t3.path_parent = t2.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE ((t0.value = 'Afghanistan')) AND ((t1.value = 'Badakhshan')) AND ((t2.value LIKE 'A%' ESCAPE '`')) AND ((t3.value = 36.68333)) LIMIT 100
{{#visualdataquery:[[name::Afghanistan]] [[states/name::Badakhshan]] [[states/cities/name::A~]][[states/cities/restaurants/name::bbb]]
|schema=Country
|?states/cities/name
|?states/cities/latitude
|?states/cities/longitude
|format=json
|pagetitle-name=article
}}
SELECT t0.page_id AS `page_id`,c0,c1,p2,c2,c2,p3,c3,p4,c4 FROM (SELECT t.page_id,p.path_parent,t.value,GROUP_CONCAT(p.path SEPARATOR 0x1e) AS p0,GROUP_CONCAT(t.value SEPARATOR 0x1e) AS c0 FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'name' GROUP BY t.page_id ) `t0` LEFT JOIN (SELECT t.page_id,p.path_parent,t.value,GROUP_CONCAT(p.path SEPARATOR 0x1e) AS p1,GROUP_CONCAT(t.value SEPARATOR 0x1e) AS c1 FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/name' GROUP BY t.page_id ) `t1` ON (((t1.page_id=t0.page_id))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value,GROUP_CONCAT(p.path SEPARATOR 0x1e) AS p2,GROUP_CONCAT(t.value SEPARATOR 0x1e) AS c2 FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/name' GROUP BY t.page_id ) `t2` ON (((t2.page_id=t0.page_id) AND (LOCATE( t1.path_parent, t2.path_parent ) = 1))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value,GROUP_CONCAT(p.path SEPARATOR 0x1e) AS p3,GROUP_CONCAT(t.value SEPARATOR 0x1e) AS c3 FROM `visualdata_numeric` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/latitude' GROUP BY t.page_id ) `t3` ON (((t3.page_id=t0.page_id) AND (t3.path_parent = t2.path_parent))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value,GROUP_CONCAT(p.path SEPARATOR 0x1e) AS p4,GROUP_CONCAT(t.value SEPARATOR 0x1e) AS c4 FROM `visualdata_numeric` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/longitude' GROUP BY t.page_id ) `t4` ON (((t4.page_id=t0.page_id) AND (t4.path_parent = t2.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE ((t0.value = 'Afghanistan')) AND ((t1.value = 'Badakhshan')) AND ((t2.value LIKE 'A%' ESCAPE '`')) GROUP BY t0.page_id LIMIT 100
{{#visualdataquery:[[name::Afghanistan]]
|schema=Country
|?states/name
|?states/state_code
|format=table
}}
SELECT t0.page_id AS `page_id`,t1.value AS `v1`,t2.value AS `v2` FROM (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'name' ) `t0` LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/name' ) `t1` ON (((t1.page_id=t0.page_id))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/state_code' ) `t2` ON (((t2.page_id=t0.page_id) AND (t2.path_parent = t1.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE ((t0.value = 'Afghanistan')) LIMIT 100
{{#visualdataquery:
[[name::Canada]][[states/name::Q~]]
|schema=Country
|?states/name=State name
|?states/cities/name=City name
|?states/cities/latitude
|limit=50
|format=datatable
}}
SELECT t0.page_id AS `page_id`,t1.value AS `v1`,t2.value AS `v2`,t3.value AS `v3` FROM (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'name' ) `t0` LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/name' ) `t1` ON (((t1.page_id=t0.page_id))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/name' ) `t2` ON (((t2.page_id=t0.page_id) AND (LOCATE( t1.path_parent, t2.path_parent ) = 1))) LEFT JOIN (SELECT t.page_id,p.path_parent,t.value FROM `visualdata_numeric` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '3' AND p.path_no_index = 'states/cities/latitude' ) `t3` ON (((t3.page_id=t0.page_id) AND (t3.path_parent = t2.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE ((t0.value = 'Canada')) AND ((t1.value LIKE 'Q%' ESCAPE '`')) LIMIT 50
See also
- Demo VisualData 1.0
- New task
- Page upload
- CRUD
- Result formats
- Dependent values
- Geolocation
- Queries
- Query cities (join queries)
- Dynamic catalogue
- Datatable cards
- Calendar
- Carousel
- Nested schemas
- Table mode
- Lua
- Official docs
support & questions: support at topway.it