Home » Find restaurants » MRT-Queen Sirikit National Convention Centre » Mall Big C Extra Rama 4 (formerly Carrefour)
Mall Big C Extra Rama 4 (formerly Carrefour)
ห้างบิ๊กซี เอ็กซ์ตร้า พระราม 4 (คาร์ฟูร์เก่า)
No. of restaurants: 5
2929, Rama 4 Rd, Khlong Tan, Khlong Toei
Bangkok
Bangkok
Website:
Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]http://www.bigc.co.th/th/stores/bigce...
Facebook:
http://www.facebook.com/bigcsupercenter
Building hours:
Mon : 09:00 - 23:00
Tue : 09:00 - 23:00
Wed : 09:00 - 23:00
Thu : 09:00 - 23:00
Fri : 09:00 - 00:00
Sat : 09:00 - 00:00
Sun : 09:00 - 23:00
You want to....
ภายในหน้านี้...
ไปอีกหน้า...
Share
Address, Map, and Directions
MRT-Queen Sirikit National Convention Centre
2929, Rama 4 Rd, Khlong Tan, Khlong Toei
Bangkok
Bangkok
Find direction to here
(Directions by Google Maps)
X
By:
or pick up and drop him where you want to find direction.
Did you mean...?
Restaurants in Mall Big C Extra Rama 4 (formerly Carrefour) (5)
Search in this bldg:
Building near Mall Big C Extra Rama 4 (formerly Carrefour) (1)
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SHOW FULL COLUMNS FROM `blds` | 41 | 41 | 27 | |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 2 | |
3 | SHOW FULL COLUMNS FROM `btses` | 33 | 33 | 25 | |
4 | SHOW FULL COLUMNS FROM `mrts` | 32 | 32 | 23 | |
5 | SHOW FULL COLUMNS FROM `members` | 46 | 46 | 23 | |
6 | SHOW FULL COLUMNS FROM `th_provinces` | 9 | 9 | 14 | |
7 | SHOW FULL COLUMNS FROM `countries` | 9 | 9 | 13 | |
8 | SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 | 2 | 2 | 0 | |
9 | 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`.`nameTh`, `BldType`.`nameEn`, `ThProvince`.`nameTh`, `ThProvince`.`nameEn`, `Country`.`name`, `Country`.`nameEn`, `PrimaryPic`.`id`, `PrimaryPic`.`file_name_s`, `PrimaryPic`.`file_name_thumb_s`, `PrimaryPic`.`caption`, `PrimaryPic`.`num_likes`, `PrimaryPic`.`member_id` 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`) LEFT JOIN `th_provinces` AS `ThProvince` ON (`Bld`.`th_province_id` = `ThProvince`.`id`) LEFT JOIN `countries` AS `Country` ON (`Bld`.`country_id` = `Country`.`id`) LEFT JOIN `blds_pics` AS `PrimaryPic` ON (`Bld`.`primary_blds_pic_id` = `PrimaryPic`.`id` AND `PrimaryPic`.`active` = 1) WHERE `Bld`.`id` = 1958 AND `Bld`.`active` = 1 LIMIT 1 | 1 | 1 | 1 | |
10 | SELECT `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` FROM `mrts` AS `Mrt` WHERE `Mrt`.`id` = 13 | 1 | 1 | 0 | |
11 | SELECT `BldType`.`nameTh`, `BldType`.`nameEn` FROM `bld_types` AS `BldType` WHERE `BldType`.`id` = 2 | 1 | 1 | 0 | |
12 | SELECT `ThProvince`.`nameTh`, `ThProvince`.`nameEn` FROM `th_provinces` AS `ThProvince` WHERE `ThProvince`.`id` = 1 | 1 | 1 | 0 | |
13 | SELECT `Country`.`name`, `Country`.`nameEn` FROM `countries` AS `Country` WHERE `Country`.`id` = 208 | 1 | 1 | 0 | |
14 | SELECT `BldsPic`.`id`, `BldsPic`.`file_name_l`, `BldsPic`.`file_name_m`, `BldsPic`.`file_name_s`, `BldsPic`.`file_name_thumb_s`, `BldsPic`.`caption`, `BldsPic`.`num_likes`, `BldsPic`.`member_id`, `BldsPic`.`bld_id` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`active` = 1 AND `BldsPic`.`bld_id` = (1958) ORDER BY `BldsPic`.`num_likes` DESC, `BldsPic`.`id` DESC LIMIT 5 | 0 | 0 | 0 | |
15 | SELECT `BldsHour`.`day_from`, `BldsHour`.`day_to`, `BldsHour`.`hour_open`, `BldsHour`.`hour_close`, `BldsHour`.`description`, `BldsHour`.`bld_id` FROM `blds_hours` AS `BldsHour` WHERE `BldsHour`.`bld_id` = (1958) ORDER BY `BldsHour`.`day_from` ASC, `BldsHour`.`day_to` ASC, `BldsHour`.`hour_open` ASC, `BldsHour`.`hour_close` ASC | 7 | 7 | 0 | |
16 | SELECT `RestsPic`.`id`, `RestsPic`.`num_likes`, `RestsPic`.`caption`, `RestsPic`.`file_name_thumb_s`, `RestsPic`.`file_name_s`, `Rest`.`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` = 1958 ORDER BY `RestsPic`.`id` DESC LIMIT 5 | 0 | 0 | 14 | |
17 | SELECT COUNT(*) AS `count` FROM `blds_pics` AS `BldsPic` WHERE `BldsPic`.`bld_id` = 1958 AND `BldsPic`.`active` = 1 | 1 | 1 | 1 | |
18 | SELECT COUNT(*) AS `total` FROM `rests_pics` WHERE `rest_id` IN ( SELECT `id` FROM `rests` WHERE `bld_id` = '1958' ) | 1 | 1 | 6 | |
19 | call geodist_nearbyBlds( 13.718500, 100.569000, 1500, 1958, 2) | 1305: PROCEDURE kinnshar_kinnsharedev.geodist_nearbyBlds does not exist | 0 |