This is the test environment server: dev.kinnshare.com
Near where
Wanna Eat/Find

Mall Terminal 21 : Building pics

< Back
Pic no. 1 from 2 Next >
Posted:
10 Dec 2011 at 20:17
By: KinnShare
ทางเข้าห้างจาก BTS
You want to....
ภายในหน้านี้...
  • Print
ไปอีกหน้า...
Share
Showing 1-2 from 2 total
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
ทางเข้าห้างจาก BTS
By: KinnShare
By: KinnShare
Showing 1-2 from 2 total
« Prev Next »
(default) 7 queries took 6 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
2SELECT `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` = 1952 AND `Bld`.`active` = 1 LIMIT 1111
3 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '1952' ) 110
4SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` LEFT JOIN `members` AS `Member` ON (`BldsPic`.`member_id` = `Member`.`id`) WHERE `BldsPic`.`active` = 1 AND `BldsPic`.`bld_id` = 1952 111
5SELECT `BldsPic`.`id`, `BldsPic`.`member_id`, `BldsPic`.`member_ip`, `BldsPic`.`bld_id`, `BldsPic`.`created`, `BldsPic`.`file_name`, `BldsPic`.`file_name_l`, `BldsPic`.`file_name_m`, `BldsPic`.`file_name_s`, `BldsPic`.`file_name_thumb_l`, `BldsPic`.`file_name_thumb_m`, `BldsPic`.`file_name_thumb_s`, `BldsPic`.`caption`, `BldsPic`.`pic_type_id`, `BldsPic`.`file_size`, `BldsPic`.`date_taken`, `BldsPic`.`active`, `BldsPic`.`modified`, `BldsPic`.`num_likes`, `Member`.`id`, `Member`.`unique_code`, `Member`.`username`, `Member`.`first_name`, `Member`.`last_name` FROM `blds_pics` AS `BldsPic` LEFT JOIN `members` AS `Member` ON (`BldsPic`.`member_id` = `Member`.`id`) WHERE `BldsPic`.`active` = 1 AND `BldsPic`.`bld_id` = 1952 ORDER BY `BldsPic`.`id` asc LIMIT 20222
6 SELECT Result.`rank` FROM ( SELECT @rownum:=@rownum+1 AS `rank`, BldsPic.`id` FROM `blds_pics` AS BldsPic, (SELECT @rownum:=0) AS R WHERE BldsPic.`bld_id` = '1952' AND BldsPic.`active` = '1' ORDER BY `BldsPic`.`id` ASC ) AS Result WHERE Result.`id` = '43' LIMIT 1 111
7 SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, BldsPic.`id` FROM `blds_pics` AS BldsPic, (SELECT @rownum:=0) AS R WHERE BldsPic.`bld_id` = '1952' AND BldsPic.`active` = '1' ORDER BY `BldsPic`.`id` ASC ) AS Result WHERE Result.`rank` BETWEEN 0 AND 2 AND Result.`rank` <> 1 ORDER BY Result.`rank` DESC LIMIT 2 111
Submit feedback to KinnShare
If you would like to submit feedback to us, report any bugs or problems using KinnShare website, or found any incorrect info. You can use the form below to contact us :-).
submitting ...