WHERE `news_article_categories`.`news_category_id` = '29' WHERE `news_article_categories`.`news_category_id` = '28' WHERE `news_article_categories`.`news_category_id` = '27' WHERE `news_article_categories`.`news_category_id` = '23' WHERE `news_article_categories`.`news_category_id` = '22' WHERE `news_article_categories`.`news_category_id` = '19' WHERE `news_article_categories`.`news_category_id` = '18' WHERE `news_article_categories`.`news_category_id` = '16' WHERE `news_article_categories`.`news_category_id` = '11'ĪND `white_label_inclusions`.`entity_type` = 'news' LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`ĪND `white_label_inclusions`.`entity_type` = 'page' SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count WHERE `white_label_versions`.`url` = ''ĪND `white_label_inclusions`.`entity_type` = 'tour' JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` SELECT `white_label_inclusions`.`entity_id` WHERE `views` curdate() AND tour_stops.active = 1) tour_stop_count

Gavin smith poker doyle brunson