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 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 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`

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` WHERE `views` curdate() AND tour_stops.active = 1) tour_stop_count

Head to Vegas to ring in the New Year spectaculary! |

Horseshoe casino new year eve