gistfile1.txt

SELECT * 
FROM   `associates` 
WHERE  `store_id` = ? 
       AND (SELECT Count(*) 
            FROM   `departments` 
                   INNER JOIN `associate_department` 
                           ON `departments`.`id` = 
                              `associate_department`.`department_id` 
            WHERE  `associate_department`.`associate_id` = `associates`.`id` 
                   AND (SELECT Count(*) 
                        FROM   `courses` 
                               INNER JOIN `course_department` 
                                       ON `courses`.`id` = 
                                          `course_department`.`course_id` 
                        WHERE  `course_department`.`department_id` = 
                               `departments`.`id` 
                               AND (SELECT Count(*) 
                                    FROM   `users` 
                                           INNER JOIN `course_user` 
                                                   ON `users`.`id` = 
                                                      `course_user`.`user_id` 
                                    WHERE  `course_user`.`course_id` = 
                                           `courses`.`id` 
                                           AND `course_user`.`is_certified` = ? 
                                           AND `users`.`id` = ?) >= 1 
                               AND `courses`.`priority` <= ? 
                               AND (SELECT Count(*) 
                                    FROM   `course_store` 
                                    WHERE  `course_store`.`course_id` = 
                                           `courses`.`id` 
                                           AND (SELECT Count(*) 
                                                FROM   `associate_types` 
                               INNER JOIN `associate_type_course_store` 
                                       ON `associate_types`.`id` = 
                               `associate_type_course_store`.`associate_type_id` 
                               WHERE 
`associate_type_course_store`.`course_store_id` = 
                               `course_store`.`id` 
                               AND `associate_types`.`id` = ?) >= 1) >= 1 
                               AND `courses`.`id` = ?) >= 1) >= 1 
       AND (SELECT Count(*) 
            FROM   `sessions` 
                   INNER JOIN `associate_session` 
                           ON `sessions`.`id` = `associate_session`.`session_id` 
            WHERE  `associate_session`.`associate_id` = `associates`.`id` 
                   AND `sessions`.`is_certified` = ? 
                   AND `sessions`.`course_id` = ?) < 1