Test query

• Controversy and Culture: Eurovision 2025, {{{authors}}}
• Chakrulo: Polyphony Among the Stars, {{{authors}}}
• A Taxi Ride to the Jvari Monastery, {{{authors}}}
• A Diligent Bus Inspector, {{{authors}}}
• Undisturbed Cat at TV 1st Channel Studio, {{{authors}}}

• Controversy and Culture: Eurovision 2025, Anna Lia Olivo
• Chakrulo: Polyphony Among the Stars, Anna Lia Olivo
• A Taxi Ride to the Jvari Monastery, Lorenzo Gianni, Manuel Primitivi
• A Diligent Bus Inspector, {{{authors}}}
• Undisturbed Cat at TV 1st Channel Studio, {{{authors}}}

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`,t1.value AS `v1` 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 schema_id = '1' AND path_no_index = 'title' ) `t0` LEFT JOIN (SELECT t.value,t.page_id,p.path_no_index,p.path,p.path_parent,p.schema_id FROM `visualdata_date` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE schema_id = '1' AND path_no_index = 'date' ) `t1` ON (((t1.page_id=t0.page_id))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE t0.schema_id = '1' AND ((t0.value IS NOT NULL)) GROUP BY t0.page_id ORDER BY v1 desc LIMIT 5

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`,GROUP_CONCAT(t2.path SEPARATOR 0x1E) AS `p2`,GROUP_CONCAT(t2.value SEPARATOR 0x1E) AS `c2`,t1.value AS `v1` 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 schema_id = '1' AND path_no_index = 'title' ) `t0` LEFT JOIN (SELECT t.value,t.page_id,p.path_no_index,p.path,p.path_parent,p.schema_id FROM `visualdata_date` `t` JOIN `visualdata_props` `p` ON ((p.id=t.prop_id)) WHERE schema_id = '1' AND path_no_index = 'date' ) `t1` ON (((t1.page_id=t0.page_id))) 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 schema_id = '1' AND path_no_index = 'authors' ) `t2` ON (((t2.page_id=t0.page_id))) JOIN `page` `page_alias` ON ((page_alias.page_id = t0.page_id)) WHERE t0.schema_id = '1' AND ((t0.value IS NOT NULL)) GROUP BY t0.page_id ORDER BY v1 desc LIMIT 5