Test query carousel
98
| page title | pictures/file | caption |
|---|---|---|
| Data:Pictures/1 | File:C012C22F-368F-4C42-A04C-15087407B322.JPG | |
| Data:Pictures/7 | File:IMG_3335_3.jpg | |
| Data:Pictures/11 | File:0c98c1419d7722415e14285de00b911a 2.JPEG | |
| Data:Pictures/8 | File:IMG_3647.jpg | |
| Data:Pictures/2 | File:6F5433CC-0802-4FFB-A3D5-EC507E10E24D.JPG |
SELECT t0.page_id AS `page_id`,p0,c0,c0,p1,c1 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 = '15' AND p.path_no_index = 'pictures/file' 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 = '15' AND p.path_no_index = 'pictures/caption' GROUP BY t.page_id ) `t1` ON (((t1.page_id=t0.page_id) AND (t1.path_parent = t0.path_parent))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE ((t0.value IS NOT NULL)) GROUP BY t0.page_id LIMIT 50