Home
Restaurants
All Comments
Share Shuan ShimBldg Eight Thonglor : Restaurant pics in the building
You want to....
ภายในหน้านี้...
ไปอีกหน้า...
Share
Sort by:
Showing 1-11 from 11 total
Showing 1-11 from 11 total
« Prev Next »
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | 2 | 2 | 0 | |
| 2 | SELECT `Bld`.`id`, `Bld`.`nameTh`, `Bld`.`nameEn`, `Bld`.`tags`, `Bld`.`descriptionTh`, `Bld`.`descriptionEn`, `Bld`.`seo_url`, `Bld`.`bld_type_id`, `Bld`.`st_addrTh`, `Bld`.`st_addrEn`, `Bld`.`directionTh`, `Bld`.`directionEn`, `Bld`.`th_province_id`, `Bld`.`country_id`, `Bld`.`lat`, `Bld`.`lng`, `Bld`.`bts_id`, `Bld`.`bts_minutes`, `Bld`.`mrt_id`, `Bld`.`mrt_minutes`, `Bld`.`tel`, `Bld`.`hours`, `Bld`.`official_website`, `Bld`.`official_directory`, `Bld`.`facebook`, `Bld`.`floors`, `Bld`.`zones`, `Bld`.`num_pics`, `Bld`.`num_rests`, `Bld`.`active`, `Bld`.`added_by_member_id`, `Bld`.`created`, `Bld`.`modified`, `Bld`.`primary_blds_pic_id`, `Bld`.`primary_pic_by_admin`, `Bld`.`primary_blds_pic_thumb_m`, `Bld`.`logo`, `Bld`.`logo_s`, `Bld`.`logo_thumb`, `Bld`.`logo_thumb_s`, `Bld`.`show_home_order`, (CONCAT(`Bld`.`nameTh`, " (", `Bld`.`nameEn`, ")")) AS `Bld__nameThEn`, `Bts`.`id`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`lat`, `Bts`.`lng`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `Mrt`.`id`, `Mrt`.`nameTh`, `Mrt`.`nameEn`, `Mrt`.`lat`, `Mrt`.`lng`, (CONCAT("MRT-", `Mrt`.`nameTh`)) AS `Mrt__full_nameTh`, (CONCAT("MRT-", `Mrt`.`nameEn`)) AS `Mrt__full_nameEn`, `BldType`.`id`, `BldType`.`nameTh`, `BldType`.`nameEn`, `BldType`.`created`, `BldType`.`modified` FROM `blds` AS `Bld` LEFT JOIN `btses` AS `Bts` ON (`Bld`.`bts_id` = `Bts`.`id`) LEFT JOIN `mrts` AS `Mrt` ON (`Bld`.`mrt_id` = `Mrt`.`id`) LEFT JOIN `bld_types` AS `BldType` ON (`Bld`.`bld_type_id` = `BldType`.`id`) WHERE `Bld`.`id` = 804 AND `Bld`.`active` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 3 | SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`bld_id` = 804 AND `BldsPic`.`active` = 1 | 1 | 1 | 0 | |
| 4 | SELECT COUNT(*) AS `count` FROM `rests_pics` AS `RestsPic` INNER JOIN rests AS `Rest` ON (`Rest`.`id` = `RestsPic`.`rest_id`) LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) WHERE `RestsPic`.`active` = 1 AND `Rest`.`bld_id` = 804 | 1 | 1 | 0 | |
| 5 | SELECT `RestsPic`.*, `Rest`.`id`, `Rest`.`rest_chain_id`, `Rest`.`nameTh`, `Rest`.`nameEn`, `Rest`.`branch_nameTh`, `Rest`.`seo_url`, `Member`.`id`, `Member`.`unique_code`, `Member`.`username` FROM `rests_pics` AS `RestsPic` INNER JOIN rests AS `Rest` ON (`Rest`.`id` = `RestsPic`.`rest_id`) LEFT JOIN `members` AS `Member` ON (`RestsPic`.`member_id` = `Member`.`id`) WHERE `RestsPic`.`active` = 1 AND `Rest`.`bld_id` = 804 ORDER BY `RestsPic`.`num_likes` desc LIMIT 60 | 11 | 11 | 28 | |
| 6 | SELECT Result.`rank` FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R, `rests` AS `Rest` WHERE `RestsPic`.`rest_id` = `Rest`.`id` AND `Rest`.`bld_id` = '804' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`num_likes` DESC ) AS Result WHERE Result.`id` = '548' LIMIT 1 | 1 | 1 | 9 | |
| 7 | SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, RestsPic.`id` FROM `rests_pics` AS RestsPic, (SELECT @rownum:=0) AS R, `rests` AS `Rest` WHERE `RestsPic`.`rest_id` = `Rest`.`id` AND `Rest`.`bld_id` = '804' AND RestsPic.`active` = '1' ORDER BY `RestsPic`.`num_likes` DESC ) AS Result WHERE Result.`rank` BETWEEN 0 AND 2 AND Result.`rank` <> 1 ORDER BY Result.`rank` DESC LIMIT 2 | 1 | 1 | 8 |
