Test query carousel: Difference between revisions
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{#visualdataquery:[[pictures/file::+]] | {{#visualdataquery:[[pictures/file::+]] | ||
|schema=Pictures | |schema=Pictures | ||
|?pictures/file | |?pictures/file | ||
|?pictures/caption | |||
|format=count | |format=count | ||
}} | }} | ||
| Line 11: | Line 11: | ||
|schema=Pictures | |schema=Pictures | ||
|?pictures/file | |?pictures/file | ||
|?pictures/caption | |||
|format=table | |format=table | ||
|limit=5 | |limit=5 | ||
| Line 19: | Line 20: | ||
|schema=Pictures | |schema=Pictures | ||
|?pictures/file | |?pictures/file | ||
|?pictures/caption | |||
|format=carousel | |format=carousel | ||
|carousel-onlimit=query | |carousel-onlimit=query | ||
Latest revision as of 12:37, 14 June 2025
98
| page title | pictures/file | caption |
|---|---|---|
| Data:Pictures/1 | File:C012C22F-368F-4C42-A04C-15087407B322.JPG | |
| Data:Pictures/2 | File:6F5433CC-0802-4FFB-A3D5-EC507E10E24D.JPG | |
| Data:Pictures/6 | File:06ba9542-f51c-4e93-b544-a941f0ef1e61.JPG | |
| Data:Pictures/7 | File:IMG_3335_3.jpg | |
| Data:Pictures/8 | File:IMG_3647.jpg |
SELECT t0.page_id AS `page_id`,GROUP_CONCAT(t0.path SEPARATOR 0x1E) AS `p0`,GROUP_CONCAT(t0.value SEPARATOR 0x1E) AS `c0`,GROUP_CONCAT(t1.path SEPARATOR 0x1E) AS `p1`,GROUP_CONCAT(t1.value SEPARATOR 0x1E) AS `c1` FROM (SELECT t.value,t.page_id,p.path_no_index,p.path,p.path_parent,p.schema_id FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '13' AND p.path_no_index = 'pictures/file' ) `t0` LEFT JOIN (SELECT t.value,t.page_id,p.path_no_index,p.path,p.path_parent,p.schema_id FROM `visualdata_text` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE p.schema_id = '13' AND p.path_no_index = 'pictures/caption' ) `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