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

Mall K Village : Building pics

< Back
Pic no. 1 from 1
Next >
Posted:
8 Jun 2011 at 20:07
By: KinnShare
ลานตรงกลาง
You want to....
ภายในหน้านี้...
  • Print
ไปอีกหน้า...
Share
Showing 1-1 from 1 total
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
ลานตรงกลาง
By: KinnShare
Showing 1-1 from 1 total
« Prev Next »
(default) 22 queries took 251 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `countries`9923
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `rests_comments`272719
4SHOW FULL COLUMNS FROM `nonmembers`3319
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';110
6SHOW FULL COLUMNS FROM `rests_pics`222221
7SHOW FULL COLUMNS FROM `rest_pic_types`6616
8SHOW FULL COLUMNS FROM `admin_tmp_pics`121219
9SHOW FULL COLUMNS FROM `blds_pics`191912
10SHOW FULL COLUMNS FROM `blds_pics_likes`5515
11SHOW FULL COLUMNS FROM `visits`7717
12SHOW FULL COLUMNS FROM `unique_visitors`5519
13SHOW FULL COLUMNS FROM `searches`101019
14SHOW FULL COLUMNS FROM `rests_comments_likes`5515
15SHOW FULL COLUMNS FROM `rests_pics_likes`5518
16SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
17SELECT `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` = 184 AND `Bld`.`active` = 1 LIMIT 1112
18 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '184' ) 1112
19SELECT 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` = 184 111
20SELECT `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` = 184 ORDER BY `BldsPic`.`id` DESC LIMIT 20111
21 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` = '184' AND BldsPic.`active` = '1' ORDER BY `BldsPic`.`id` DESC ) AS Result WHERE Result.`id` = '11' LIMIT 1 111
22 SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, BldsPic.`id` FROM `blds_pics` AS BldsPic, (SELECT @rownum:=0) AS R WHERE BldsPic.`bld_id` = '184' 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 001
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 ...