| 3 | SELECT `Pages`.`id`, `Pages`.`title`, `Pages`.`date`, `Pages`.`category`, `Pages`.`keywords`, `Pages`.`description`, `Pages`.`content`, `Pages`.`user_id`, `Pages`.`start_date`, `Pages`.`end_date`, `Pages`.`status`, `Pages`.`created`, `Pages`.`created_by_user_id`, `Pages`.`modified`, `Pages`.`modified_by_user_id`, `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`user`, `User`.`password`, `User`.`category_id`, `User`.`related_user_id`, `User`.`created`, `User`.`created_by_user_id`, `User`.`modified`, `User`.`modified_by_user_id`, `Created`.`id`, `Created`.`first_name`, `Created`.`last_name`, `Created`.`user`, `Created`.`password`, `Created`.`category_id`, `Created`.`related_user_id`, `Created`.`created`, `Created`.`created_by_user_id`, `Created`.`modified`, `Created`.`modified_by_user_id`, `Modified`.`id`, `Modified`.`first_name`, `Modified`.`last_name`, `Modified`.`user`, `Modified`.`password`, `Modified`.`category_id`, `Modified`.`related_user_id`, `Modified`.`created`, `Modified`.`created_by_user_id`, `Modified`.`modified`, `Modified`.`modified_by_user_id` FROM `pages` AS `Pages` LEFT JOIN `users` AS `User` ON (`Pages`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `Created` ON (`Pages`.`created_by_user_id` = `Created`.`id`) LEFT JOIN `users` AS `Modified` ON (`Pages`.`modified_by_user_id` = `Modified`.`id`) WHERE `Pages`.`category` = "skill sets" AND ( (`Pages`.`start_date` = '0000-00-00 00:00:00' AND `Pages`.`end_date` = '0000-00-00 00:00:00') OR ('2010-09-05 00:00:00' >= `Pages`.`start_date` AND `Pages`.`end_date` = '0000-00-00 00:00:00') OR ('2010-09-05 00:00:00' < `Pages`.`end_date` AND `Pages`.`start_date` = '0000-00-00 00:00:00') OR ('2010-09-05 00:00:00' >= `Pages`.`start_date` AND '2010-09-05 00:00:00' < `Pages`.`end_date` AND `Pages`.`start_date` != '0000-00-00 00:00:00' AND `Pages`.`end_date` != '0000-00-00 00:00:00') OR (`Pages`.`start_date` = '0000-00-00 00:00:00' AND `Pages`.`end_date` = '0000-00-00 00:00:00') ) AND `Pages`.`status` = 0 ORDER BY `Pages`.`date` DESC LIMIT 1 | | 1 | 1 | 9 |
