SELECT * FROM forms WHERE formType="Competition" AND activated="Y" AND DATE_FORMAT(startDate,'%Y-%m-%d') <= DATE_FORMAT(NOW(),'%Y-%m-%d') AND DATE_FORMAT(endDate,'%Y-%m-%d') >= DATE_FORMAT(NOW(),'%Y-%m-%d') AND formID IN (0,378,379,684,700,766,863,1024,1147,1154,1158,1233,1237,1333,1338,1486,1487,1772,1799,1811,2104,2105,2317,2350,2546,2547,2753,4073) ORDER BY startDate ASC, endDate ASC