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

Mall Midtown Asoke : Building pics

< Back
Pic no. 1 from 2 Next >
Posted:
22 Dec 2011 at 03:38
By: KinnShare
You want to....
ภายในหน้านี้...
  • Print
ไปอีกหน้า...
Share
Showing 1-2 from 2 total
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
By: KinnShare
By: KinnShare
Showing 1-2 from 2 total
« Prev Next »
(default) 10 queries took 64 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `rests_rest_features`3311
2SHOW FULL COLUMNS FROM `rest_features`101019
3SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
4SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
5SELECT `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` = 2019 AND `Bld`.`active` = 1 LIMIT 1111
6 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '2019' ) 1128
7SELECT 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` = 2019 111
8SELECT `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` = 2019 ORDER BY `BldsPic`.`id` DESC LIMIT 20222
9 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` = '2019' AND BldsPic.`active` = '1' ORDER BY `BldsPic`.`id` DESC ) AS Result WHERE Result.`id` = '59' LIMIT 1 111
10 SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, BldsPic.`id` FROM `blds_pics` AS BldsPic, (SELECT @rownum:=0) AS R WHERE BldsPic.`bld_id` = '2019' AND BldsPic.`active` = '1' ORDER BY `BldsPic`.`id` DESC ) 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 ...