Random Pastebin Posts, Always Fun to read, and to find what your looking for
Code:
SELECT `Restaurant`.`id`, `Restaurant`.`name`, `Restaurant`.`address`, `Restaurant`.`zipcode`, `Restaurant`.`email`, `Restaurant`.`website`, `Restaurant`.`latitude`, `Restaurant`.`longitude`, `Restaurant`.`logo_file`, `Restaurant`.`average_rating`, `Restaurant`.`total_points`, `Restaurant`.`total_votes`, `Restaurant`.`area_id`, `Area`.`id`, `Area`.`name`, `Area`.`zipcode`, `Area`.`latitude`, `Area`.`longitude`, `Area`.`city_id`, `RestaurantAttribute`.`id`, `RestaurantAttribute`.`average_cost`, `RestaurantAttribute`.`buffet`, `RestaurantAttribute`.`catering`, `RestaurantAttribute`.`home_delivery`, `RestaurantAttribute`.`reservation`, `RestaurantAttribute`.`valet_parking`, `RestaurantAttribute`.`wifi_access`, `RestaurantAttribute`.`smoking_lounge`, `RestaurantAttribute`.`liquor_servered`, `RestaurantAttribute`.`24_hours_open`, `RestaurantAttribute`.`vegetarian`, `RestaurantAttribute`.`open_sitting`, `RestaurantAttribute`.`roof_top`, `RestaurantAttribute`.`lodging`, `RestaurantAttribute`.`party_hall`, `RestaurantAttribute`.`credit_card`, `RestaurantAttribute`.`food_coupons`, `RestaurantAttribute`.`review`, `RestaurantAttribute`.`restaurant_id` FROM `restaurants` AS `Restaurant` LEFT JOIN `areas` AS `Area` ON (`Restaurant`.`area_id` = `Area`.`id`) LEFT JOIN `restaurant_attributes` AS `RestaurantAttribute` ON (`RestaurantAttribute`.`restaurant_id` = `Restaurant`.`id`) WHERE 1 = 1 LIMIT 20
136