Identical queries but LIMIT 100 returns 0 rows, LIMIT 99 returns what you would expect.

SELECT `a`.*,`a`.`content` AS `date`,`lawyer`.`content` AS `lawyer`,`lawyer_name`.`title` AS `lawyer_name`,`locationName`.`content` AS `locationName`,`name`.`content` AS `name`,`email`.`content` AS `email`,`phone`.`content` AS `phone`,`best_contact_time`.`content` AS `best_contact_time`,`legal_issue`.`content` AS `legal_issue` FROM `contact` AS `a`LEFT JOIN `contact` AS `lawyer` ON (`lawyer`.`object` = `a`.`id` AND `lawyer`.`type` = "lawyer") LEFT JOIN `content` AS `lawyer_name` ON (`lawyer`.`content` = `lawyer_name`.`id` AND `lawyer_name`.`type` = "lawyer") LEFT JOIN `contact` AS `locationName` ON (`locationName`.`object` = `a`.`id` AND `locationName`.`type` = "locationName") LEFT JOIN `contact` AS `name` ON (`name`.`object` = `a`.`id` AND `name`.`type` = "name") LEFT JOIN `contact` AS `email` ON (`email`.`object` = `a`.`id` AND `email`.`type` = "email") LEFT JOIN `contact` AS `phone` ON (`phone`.`object` = `a`.`id` AND `phone`.`type` = "phone") LEFT JOIN `contact` AS `best_contact_time` ON (`best_contact_time`.`object` = `a`.`id` AND `best_contact_time`.`type` = "best_contact_time") LEFT JOIN `contact` AS `legal_issue` ON (`legal_issue`.`object` = `a`.`id` AND `legal_issue`.`type` = "legal_issue") WHERE `a`.`content` >= CONVERT_TZ("2016-01-01 00:00", "America/Vancouver", "UTC") AND `a`.`content` <= CONVERT_TZ("2016-01-04 23:59", "America/Vancouver", "UTC") AND `a`.`object` = "1712" AND `a`.`type` = "contact" ORDER BY `date` DESC LIMIT 100