API tools faq
paste
Advertisement
Guest User

Harsha

a guest
Oct 28th, 2010
73
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.47 KB | None | 0 0
raw download clone embed print report
  1. SELECT `Item`.`id`, `Item`.`module_id`, `Item`.`item_id`, `Module`.`id`, `Module`.`name`, `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`activation_key`, `User`.`file`, `User`.`status`, `User`.`birthday`, `User`.`gender`, `User`.`address`, `User`.`cellphone`, `User`.`cellphone_activation_code`, `User`.`cellphone_status`, `User`.`latitude`, `User`.`longitude`, `User`.`city_id`, `User`.`user_group_id`, `User`.`user_occupation_id`, `User`.`created`, `User`.`modified`, `Restaurant`.`id`, `Restaurant`.`name`, `Restaurant`.`slug`, `Restaurant`.`file`, `Restaurant`.`address`, `Restaurant`.`landmark`, `Restaurant`.`area_id`, `Restaurant`.`city_id`, `Restaurant`.`telephone`, `Restaurant`.`email`, `Restaurant`.`website`, `Restaurant`.`latitude`, `Restaurant`.`longitude`, `Restaurant`.`mapaddress`, `Restaurant`.`created`, `Restaurant`.`modified`, `Dish`.`id`, `Dish`.`name`, `Dish`.`slug`, `Dish`.`preparation`, `Dish`.`price`, `Dish`.`restaurant_id`, `Dish`.`dish_category_id`, `Dish`.`created`, `Dish`.`modified`, `Event`.`id`, `Event`.`name`, `Event`.`file`, `Event`.`start_time`, `Event`.`end_time`, `Event`.`email`, `Event`.`telephone`, `Event`.`address`, `Event`.`bring_friends`, `Event`.`event_category_id`, `Event`.`event_subcategory_id`, `Event`.`event_organiser_id`, `Buffet`.`id`, `Buffet`.`name`, `Buffet`.`description`, `Buffet`.`restaurant_id`, `Buffet`.`created`, `Buffet`.`modified` FROM `items` AS `Item` LEFT JOIN `modules` AS `Module` ON (`Item`.`module_id` = `Module`.`id`) LEFT JOIN `users` AS `User` ON (`Item`.`item_id` = `User`.`id`) LEFT JOIN `restaurants` AS `Restaurant` ON (`Item`.`item_id` = `Restaurant`.`id`) LEFT JOIN `dishes` AS `Dish` ON (`Item`.`item_id` = `Dish`.`id`) LEFT JOIN `events` AS `Event` ON (`Item`.`item_id` = `Event`.`id`) LEFT JOIN `buffets` AS `Buffet` ON (`Item`.`item_id` = `Buffet`.`id`) WHERE `Item`.`module_id` = 1 AND `Item`.`item_id` = 1 LIMIT 1
  2.  
  3.  
  4.  
  5. SELECT `Review`.`id`, `Review`.`pid`, `Review`.`review_message`, `Review`.`item_id`, `Review`.`commenters_item_id`, `Review`.`created`, `Review`.`modified` FROM `reviews` AS `Review` WHERE `Review`.`pid` = 0 AND `Review`.`item_id` = (1)
  6.  
  7. SELECT `ReviewReply`.`id`, `ReviewReply`.`pid`, `ReviewReply`.`review_message`, `ReviewReply`.`item_id`, `ReviewReply`.`commenters_item_id`, `ReviewReply`.`created`, `ReviewReply`.`modified` FROM `reviews` AS `ReviewReply` WHERE `ReviewReply`.`pid` != 0 AND `ReviewReply`.`item_id` = (1)
  8.  
  9. SELECT `Review`.`id`, `Review`.`pid`, `Review`.`review_message`, `Review`.`item_id`, `Review`.`commenters_item_id`, `Review`.`created`, `Review`.`modified`, `Item`.`id`, `Item`.`module_id`, `Item`.`item_id` FROM `reviews` AS `Review` LEFT JOIN `items` AS `Item` ON (`Review`.`item_id` = `Item`.`id`) WHERE `Review`.`commenters_item_id` = 1 AND `Review`.`pid` = 0 ORDER BY `Review`.`created` DESC
  10.  
  11. SELECT `Item`.`id`, `Item`.`module_id`, `Item`.`item_id` FROM `items` AS `Item` WHERE `Item`.`id` = 3
  12.  
  13. SELECT `Item`.`id`, `Item`.`module_id`, `Item`.`item_id` FROM `items` AS `Item` WHERE `Item`.`id` = 3
  14.  
  15.    
  16. SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`username`, `User`.`file` FROM `users` AS `User` WHERE `User`.`id` = 2
  17.  
  18.    
  19. SELECT `Restaurant`.`id`, `Restaurant`.`name`, `Restaurant`.`slug`, `Restaurant`.`file`, `Restaurant`.`area_id`, `Restaurant`.`city_id` FROM `restaurants` AS `Restaurant` WHERE `Restaurant`.`id` = 2
  20.  
  21.    
  22. SELECT `Area`.`id`, `Area`.`name`, `Area`.`slug`, `Area`.`zipcode`, `Area`.`lat`, `Area`.`lon`, `Area`.`city_id` FROM `areas` AS `Area` WHERE `Area`.`id` = 309
  23.  
  24.  
  25.    
  26. SELECT `Item`.`id`, `Item`.`module_id`, `Item`.`item_id` FROM `items` AS `Item` WHERE `Item`.`id` = 5
  27.  
  28.    
  29. SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`username`, `User`.`file` FROM `users` AS `User` WHERE `User`.`id` = 1
  30.  
  31.    
  32. SELECT `Restaurant`.`id`, `Restaurant`.`name`, `Restaurant`.`slug`, `Restaurant`.`file`, `Restaurant`.`area_id`, `Restaurant`.`city_id` FROM `restaurants` AS `Restaurant` WHERE `Restaurant`.`id` = 1
  33.  
  34.    
  35. SELECT `Area`.`id`, `Area`.`name`, `Area`.`slug`, `Area`.`zipcode`, `Area`.`lat`, `Area`.`lon`, `Area`.`city_id` FROM `areas` AS `Area` WHERE `Area`.`id` = 3
  36.  
  37.  
  38.    
  39. SELECT `Item`.`id`, `Item`.`module_id`, `Item`.`item_id` FROM `items` AS `Item` WHERE `Item`.`id` = 2
  40.    
  41. SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`username`, `User`.`file` FROM `users` AS `User` WHERE `User`.`id` = 1
  42.    
  43. SELECT `Restaurant`.`id`, `Restaurant`.`name`, `Restaurant`.`slug`, `Restaurant`.`file`, `Restaurant`.`area_id`, `Restaurant`.`city_id` FROM `restaurants` AS `Restaurant` WHERE `Restaurant`.`id` = 1
  44.    
  45. SELECT `Area`.`id`, `Area`.`name`, `Area`.`slug`, `Area`.`zipcode`, `Area`.`lat`, `Area`.`lon`, `Area`.`city_id` FROM `areas` AS `Area` WHERE `Area`.`id` = 3
  46.  
  47.  
  48. SELECT `ReviewReply`.`id`, `ReviewReply`.`pid`, `ReviewReply`.`review_message`, `ReviewReply`.`item_id`, `ReviewReply`.`commenters_item_id`, `ReviewReply`.`created`, `ReviewReply`.`modified` FROM `reviews` AS `ReviewReply` WHERE `ReviewReply`.`pid` != 0 AND `ReviewReply`.`pid` IN (3, 5, 1)      2   2   1   maybe slow
  49. SELECT `Item`.`id`, `Item`.`module_id`, `Item`.`item_id` FROM `items` AS `Item` WHERE `Item`.`id` = 2
  50.  
  51. SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`username`, `User`.`file` FROM `users` AS `User` WHERE `User`.`id` = 1      1   1   1  
  52. SELECT `Restaurant`.`id`, `Restaurant`.`name`, `Restaurant`.`slug`, `Restaurant`.`file`, `Restaurant`.`area_id`, `Restaurant`.`city_id` FROM `restaurants` AS `Restaurant` WHERE `Restaurant`.`id` = 1
  53.  
  54.    
  55. SELECT `Item`.`id`, `Item`.`module_id`, `Item`.`item_id` FROM `items` AS `Item` WHERE `Item`.`id` = 3
  56.    
  57. SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`username`, `User`.`file` FROM `users` AS `User` WHERE `User`.`id` = 2
  58.    
  59. SELECT `Restaurant`.`id`, `Restaurant`.`name`, `Restaurant`.`slug`, `Restaurant`.`file`, `Restaurant`.`area_id`, `Restaurant`.`city_id` FROM `restaurants` AS `Restaurant` WHERE `Restaurant`.`id` = 2
  60.  
  61. SELECT `User`.`id`, `User`.`first_name`, `User`.`last_name`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`activation_key`, `User`.`file`, `User`.`status`, `User`.`birthday`, `User`.`gender`, `User`.`address`, `User`.`cellphone`, `User`.`cellphone_activation_code`, `User`.`cellphone_status`, `User`.`latitude`, `User`.`longitude`, `User`.`city_id`, `User`.`user_group_id`, `User`.`user_occupation_id`, `User`.`created`, `User`.`modified` FROM `users` AS `User` WHERE `User`.`id` = 1 LIMIT 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!