Array ( [0] => 00000 [1] => [2] => )
( (SELECT 'mostRecent' as categoryId, 'mostRecent' as action, news.id, news.position, news.comments, news.viewed, (select ni.filename from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as filename, (select ni.alt from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as alt, i18n.title as title, i18n.textCleared, cat.title as parentName, c.id as parentId, news.url, news.adate, c.url as categoryUrl, news.adate FROM news LEFT JOIN news_i18n i18n on i18n.newsId = news.id LEFT JOIN categories as c on c.id = news.categoryId LEFT JOIN categories_i18n as cat on cat.categoryId = news.categoryId WHERE news.isactive = 1 AND c.isactive = 1 AND (pdate <= '2020-08-08 23:59:59') AND c.isactive = 1 ORDER BY news.adate desc LIMIT 6) ) UNION ( SELECT 'slider' as categoryId, 'slider' as action, news.id, news.position, news.comments, news.viewed, (select ni.filename from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as filename, (select ni.alt from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as alt, news_i18n.title as title, news_i18n.textCleared, cat.title as parentName, c.id as parentId, news.url, news.adate, c.url as categoryUrl, news.adate FROM slider LEFT JOIN news on news.id = slider.relid LEFT JOIN news_i18n on news_i18n.newsId = slider.relid LEFT JOIN categories as c on c.id = news.categoryId LEFT JOIN categories_i18n as cat on cat.categoryId = news.categoryId WHERE news.isactive = 1 AND (pdate <= '2020-08-08 23:59:59') GROUP by news.id ORDER BY slider.position asc, news.id DESC ) UNION ( (SELECT 'mostViewed' as categoryId, 'mostViewed' as action, news.id, news.position, news.comments, news.viewed, (select ni.filename from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as filename, (select ni.alt from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as alt, i18n.title as title, i18n.textCleared, cat.title as parentName, c.id as parentId, news.url, news.adate, c.url as categoryUrl, news.adate FROM news LEFT JOIN news_i18n i18n on i18n.newsId = news.id LEFT JOIN categories as c on c.id = news.categoryId LEFT JOIN categories_i18n as cat on cat.categoryId = news.categoryId WHERE news.isactive = 1 AND c.isactive = 1 AND (pdate >= '2020-07-29 00:00:00' AND pdate <= '2020-08-08 23:59:59') ORDER BY news.viewed desc LIMIT 10) ) UNION ( (SELECT 'mostCommented' as categoryId, 'mostCommented' as action, news.id, news.position, news.comments, news.viewed, (select ni.filename from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as filename, (select ni.alt from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as alt, i18n.title as title, i18n.textCleared, cat.title as parentName, c.id as parentId, news.url, news.adate, c.url as categoryUrl, news.adate FROM news LEFT JOIN news_i18n i18n on i18n.newsId = news.id LEFT JOIN categories as c on c.id = news.categoryId LEFT JOIN categories_i18n as cat on cat.categoryId = news.categoryId WHERE news.isactive = 1 AND c.isactive = 1 AND (pdate >= '2020-07-29 00:00:00' AND pdate <= '2020-08-08 23:59:59') ORDER BY news.comments desc LIMIT 10) ) UNION ( (SELECT 'top' as categoryId, 'top' as action, news.id, news.position, news.comments, news.viewed, (select ni.filename from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as filename, (select ni.alt from news_images ni where ni.contId = news.id order by ismain desc, position asc limit 1) as alt, news_i18n.title, news_i18n.textCleared, 'top' as parentName, c.id as parentId, news.url, news.adate, c.url as categoryUrl, news.adate FROM news LEFT JOIN categories as c on c.id = news.categoryId LEFT JOIN news_i18n on news_i18n.newsId = news.id WHERE (pdate >= '2020-08-06 00:00:00' AND pdate <= '2020-08-08 23:59:59') ORDER BY news.viewed desc LIMIT 1))