SELECT mi_yarisma_id, 0 as total FROM mi_yarisma WHERE durum = 1 ORDER BY mi_yarisma_id DESC LIMIT 0, 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 ('33572', '33570', '33569', '33567', '33565', '33562', '33558', '33557', '33556')