|
|
| Line 23: |
Line 23: |
| |format=template | | |format=template |
| |order=date desc | | |order=date desc |
| | |debug=true |
| |limit=5 | | |limit=5 |
| }} | | }} |
Revision as of 15:52, 8 April 2025
kargimokalake is a platform for Georgian citizens who ...
Latest Articles
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(t3.path SEPARATOR 0x1E) AS `p3`,GROUP_CONCAT(t3.value SEPARATOR 0x1E) AS `c3`,t3.value AS `v3` 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' ) `t3` ON (((t3.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 v3 desc LIMIT 5
