SELECT evn.id, evn.title, evn.description, evn.mid, evn.uid, evn.startDate, evn.endDate, evn.website, evn.status, evn.cdt, evn.is_featured, evn.added_by_admin, ua.slug, u.fname, u.lname, u.uname, devc.catid AS default_cat_id, evc.categoryId AS categoryId, ui.filename, ui.uri, clsCdn.domain FROM (`dts_events` evn) LEFT JOIN `dts_urlAliases` ua ON `ua`.`pid` = `evn`.`id` AND ua.tid = 8 LEFT JOIN `dts_users` u ON `u`.`id` = `evn`.`uid` LEFT JOIN `dts_eventsCategories` evc ON `evc`.`eventId` = `evn`.`id` LEFT JOIN `dts_defaultCategory` devc ON `evc`.`categoryId` = `devc`.`catid` AND devc.type = 'event-category' AND devc.mid = '4' LEFT JOIN `dts_file_managed` ui ON `evn`.`id` = `ui`.`pid` AND ui.filetype = 20 LEFT JOIN `dts_cdns` clsCdn ON `clsCdn`.`id` = `ui`.`cdnId` WHERE `evn`.`status` = 1 AND `evn`.`mid` NOT IN ('52', '53', '57', '59', '60', '63', '64', '65', '66', '67', '68', '69', '72', '73', '76', '78', '80', '81', '82', '83', '84', '85', '86', '88', '90', '91', '92', '94', '95', '96', '97', '98', '99', '100', '102', '103', '104', '105', '106', '107', '108', '109', '112', '113', '122', '123', '125', '126', '127', '128', '129', '130', '134', '135', '136', '138', '140', '141', '142', '143', '144', '145', '146', '147', '148', '174', '178', '179', '180', '181', '182', '188', '189', '190', '191', '192', '193', '194', '195', '196', '197', '198', '199', '200', '201', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '230', '231', '232', '233', '234', '235', '236', '237', '238', '239', '240', '241', '242', '243', '244', '245', '246', '247', '248', '249', '250', '251', '252', '253', '254', '255', '256', '257', '258', '259', '260', '261', '262', '263', '264', '265', '266', '267', '268', '269', '270', '271', '272', '273', '274', '275', '276', '277', '278', '279', '280', '281', '282', '283', '284', '285', '292', '293', '294', '295', '296', '297', '298', '299', '300', '301', '302', '303', '304', '306', '307', '308', '309', '310', '311', '312', '313', '314', '315', '316', '317', '318', '319', '320', '321', '322', '323', '324', '325', '326', '327', '328', '329', '330', '331', '332', '333', '334', '335', '336', '337', '338', '339', '340', '341', '342', '343', '344', '345', '346', '347', '348', '349', '350', '351', '352', '353', '354', '355', '356', '357', '358', '359', '360', '361', '362', '363', '364', '365', '366', '367', '368', '369', '370', '371', '372', '373', '374', '375', '376', '377', '378', '379', '380', '381', '382', '383', '384', '385', '386', '387', '388', '390', '391', '392', '393', '394', '395', '396', '397', '398', '399', '400', '401', '402', '403', '404', '405', '406', '407', '408', '409', '410', '411', '412', '413', '414', '415', '416', '417', '418', '419', '420', '422', '423', '424', '425', '426', '427', '428', '429', '430', '431', '432', '433', '434', '435', '436', '438', '439', '440', '441', '442', '443', '444', '445', '446', '447', '448', '449', '450', '451', '452', '453', '454', '455', '456', '457', '458', '459', '460', '461', '462', '463', '464', '465', '466', '467', '468', '469', '470', '471', '472', '473', '474', '475', '476', '477', '478', '479', '480', '481', '482', '483', '484', '485', '486', '487', '488', '489', '490', '491', '492', '493', '494', '495', '496', '497', '498', '499', '500', '513', '514', '516', '517', '518', '519', '520', '521', '522', '523', '524', '525', '526', '527', '528', '529', '530', '531', '532', '533', '534', '535', '536', '537', '538', '539', '540', '541', '542', '543', '544', '545', '546', '547', '548', '549', '550', '551', '552', '553', '554', '555', '556', '557', '558', '559', '560', '561', '562', '563', '564', '565', '566', '567', '568', '569', '570', '571', '572', '573', '574', '575', '576', '577', '578', '579', '580', '581', '582', '583', '584') AND ((evn.startDate BETWEEN '1969-12-31 19:00:00' AND '1969-12-31 19:00:00') OR (evn.endDate BETWEEN '1969-12-31 19:00:00' AND '1969-12-31 19:00:00')) GROUP BY `evn`.`id` ORDER BY `evn`.`startDate` ASC