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

Mall La Villa Phahonyothin : Building pics

< Back
Pic no. 1 from 3 Next >
Posted:
2 Dec 2011 at 00:29
By: KinnShare
You want to....
ภายในหน้านี้...
  • Print
ไปอีกหน้า...
Share
Showing 1-3 from 3 total
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
By: KinnShare
By: KinnShare
Showing 1-3 from 3 total
« Prev Next »
(default) 12 queries took 85 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `btses`333317
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';113
3SHOW FULL COLUMNS FROM `mrts`323219
4SHOW FULL COLUMNS FROM `blds_pics_likes`5524
5SHOW FULL COLUMNS FROM `external_reviews_likes`5518
6SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
7SELECT `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` = 1971 AND `Bld`.`active` = 1 LIMIT 1110
8 SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '1971' ) 110
9SELECT 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` = 1971 110
10SELECT `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` = 1971 ORDER BY `BldsPic`.`num_likes` desc LIMIT 20332
11 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` = '1971' AND BldsPic.`active` = '1' ORDER BY `BldsPic`.`num_likes` DESC ) AS Result WHERE Result.`id` = '34' LIMIT 1 111
12 SELECT * FROM ( SELECT @rownum:=@rownum+1 AS `rank`, BldsPic.`id` FROM `blds_pics` AS BldsPic, (SELECT @rownum:=0) AS R WHERE BldsPic.`bld_id` = '1971' AND BldsPic.`active` = '1' ORDER BY `BldsPic`.`num_likes` 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 ...