SQL: SELECT i.id AS `id`, i.`title`, i.`alias` AS `alias`, i.`introtext`, i.`fulltext`, i.`gallery`, IF(i.created_by_alias<>'', i.created_by_alias, u.name) AS `author`, i.created_by AS `author_id`, i.catid AS `catid`, i.featured AS `featured`, c.alias AS `categoryalias`, i.`video`, i.`created` AS `real_create`, i.`hits` AS `hits`, IF(i.`modified`<>'0000-00-00 00:00:00',i.`modified`, i.`created`) AS `modified`, UNIX_TIMESTAMP(i.created) AS s4rss_created FROM #__k2_items AS i LEFT JOIN #__k2_categories AS c ON c.id = i.catid LEFT JOIN #__users AS u ON u.id = i.created_by WHERE i.`access` IN (1) AND c.`access` IN (1) AND i.published = 1 AND i.trash = 0 AND c.published = 1 AND c.trash = 0 AND c.id IN (13,44,74,121,21,53,85,15,73,17,114,120) AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2017-02-25 13:35:51' AND i.publish_up >= '2017-02-18 19:35:51' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-02-25 13:35:51' ) GROUP BY `id` ORDER BY Rand() LIMIT 30
Error:
Count Rows: 0Array ( )