SELECT m.mi_yarisma_id, COUNT(t.yarisma_id) as total FROM mi_yarisma m LEFT JOIN trend t ON t.yarisma_id = m.mi_yarisma_id AND t.tarih >= DATE_SUB(NOW(), INTERVAL 10 DAY) WHERE durum = 1 AND sinif_id = '13' GROUP BY m.mi_yarisma_id ORDER BY total DESC LIMIT 18, 9
SELECT `mi_user`.`adi` AS ekleyen_adi, `mi_user`.`soyadi` AS ekleyen_soyadi, `mi_yarisma`.*, `mi_yarisma`.`adi` AS yarisma_adi, `mi_sinif`.`adi` AS sinif_adi, `mi_unite`.`adi` AS unite_adi, `mi_ders`.`adi` AS ders_adiFROM (`mi_yarisma`)JOIN `mi_ders` ON `mi_ders`.`mi_ders_id` = `mi_yarisma`.`ders_id`JOIN `mi_sinif` ON `mi_sinif`.`mi_sinif_id` = `mi_yarisma`.`sinif_id`JOIN `mi_unite` ON `mi_unite`.`mi_unite_id` = `mi_yarisma`.`unite_id`JOIN `mi_user` ON `mi_user`.`user_id` = `mi_yarisma`.`ekleyen_id`WHERE `mi_yarisma`.`mi_yarisma_id` IN ('28364', '23446', '10964', '29915', '185', '5355', '33154', '8779', '15065')