Kriminal.lv

0 - SQL=SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM krm_k2_items as i RIGHT JOIN krm_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-10-21 23:28:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-10-21 23:28:35' ) AND c.id IN (1,5,6,7,9,10,11,12,15,17,18,20,21,23,24,28,29,30,31,32,33,34,35,36,37,38,41) AND i.featured = 1 ORDER BY i.publish_up DESC LIMIT 0, 4

Вернуться на Домашнюю страницу: Домашняя страница.