1 | SELECT `Project`.`id`, `Project`.`contest_id`, `Project`.`user_id`, `Project`.`organization_id`, `Project`.`name`, `Project`.`participants`, `Project`.`status`, `Project`.`rating`, `Project`.`file`, `Project`.`file_1`, `Project`.`file_2`, `Project`.`file_3`, `Project`.`file_4`, `Project`.`created`, `Project`.`modified`, `Project`.`youtube`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`jobtitle`, `User`.`organization_id`, `User`.`phone`, `User`.`profile_confirmed`, `User`.`role`, `User`.`created`, `User`.`modified`, `User`.`auth_token`, `User`.`bio`, `User`.`avatar`, `User`.`contest_4_confirmed`, `User`.`contest_5_confirmed`, `User`.`company`, `User`.`contest_7_confirmed`, `User`.`contest_8_confirmed`, `Organization`.`id`, `Organization`.`contest_id`, `Organization`.`name`, `Organization`.`region` FROM `fcprc_contest`.`projects` AS `Project` LEFT JOIN `fcprc_contest`.`users` AS `User` ON (`Project`.`user_id` = `User`.`id`) LEFT JOIN `fcprc_contest`.`organizations` AS `Organization` ON (`Project`.`organization_id` = `Organization`.`id`) WHERE `Project`.`contest_id` = 3 AND `Project`.`status` = 'approved' AND `Project`.`rating` BETWEEN 1 AND 10 | | 64 | 64 | 0 |
2 | SELECT `Section`.`id`, `Section`.`name`, `Section`.`contest_id`, `Section`.`parent_id`, `Section`.`type`, `ProjectsSection`.`project_id`, `ProjectsSection`.`section_id` FROM `fcprc_contest`.`sections` AS `Section` JOIN `fcprc_contest`.`projects_sections` AS `ProjectsSection` ON (`ProjectsSection`.`project_id` IN (638, 769, 862, 885, 1011, 1077, 1250, 1373, 1479, 1519, 1523, 1575, 1597, 1679, 1760, 1771, 1842, 2086, 2435, 2587, 2687, 2707, 2737, 2738, 2771, 2773, 2799, 2966, 2969, 2993, 3016, 3049, 3066, 3205, 3217, 3378, 3552, 3585, 3670, 3695, 3718, 3794, 3824, 3834, 3875, 4004, 4013, 4017, 4055, 4228, 4287, 4292, 4299, 4325, 4478, 4537, 4619, 5069, 5085, 5136, 5375, 5472, 5535, 5544) AND `ProjectsSection`.`section_id` = `Section`.`id`) | | 128 | 128 | 0 |