SELECT `favoritesupplier`.`id` AS `id`, `favoritesupplier`.`user_id` AS `user_id`, `favoritesupplier`.`supplier_id` AS `supplier_id`, `favoritesupplier`.`created` AS `created` FROM `favorite_suppliers` AS `favoritesupplier` LEFT JOIN `friend_requests` ON (`friend_requests`.`user_id` = `favoritesupplier`.`user_id`)