array(4) {
  ["hasError"]=>
  bool(false)
  ["ResponseObj"]=>
  array(1) {
    ["Items"]=>
    array(4) {
      [0]=>
      array(41) {
        ["row_num"]=>
        string(1) "1"
        ["uid"]=>
        string(5) "13933"
        ["master_id"]=>
        string(3) "431"
        ["locale"]=>
        string(2) "en"
        ["ranking"]=>
        string(1) "1"
        ["display_date"]=>
        string(19) "2021-01-01 00:00:00"
        ["store"]=>
        string(3) "cwb"
        ["title"]=>
        string(16) "SOGO Weekly News"
        ["event_period"]=>
        string(14) "20/1-26/1/2021"
        ["template"]=>
        string(1) "1"
        ["description"]=>
        string(0) ""
        ["pdf"]=>
        string(0) ""
        ["url_name"]=>
        string(0) ""
        ["happening"]=>
        string(1) "1"
        ["highlight"]=>
        string(1) "1"
        ["show_at_index"]=>
        string(1) "1"
        ["thumbnail"]=>
        string(88) "/uploads/images/mainsite/event%26promotion/original_image/20210119/200121_CWB_SN-376.jpg"
        ["thumb_alt"]=>
        string(0) ""
        ["index_image"]=>
        string(90) "/uploads/images/mainsite/event%26promotion/theme202101/2020_new_year_mock_up_sn_cwb_v2.jpg"
        ["index_alt"]=>
        string(0) ""
        ["link"]=>
        string(0) ""
        ["popup_type"]=>
        string(1) "1"
        ["happening_end_date"]=>
        string(19) "2021-11-30 00:00:00"
        ["extracted_pdf"]=>
        string(1) "0"
        ["version"]=>
        string(2) "18"
        ["created_by"]=>
        string(2) "19"
        ["created_date"]=>
        string(19) "2020-10-20 16:59:58"
        ["created_ip"]=>
        string(15) "220.241.212.216"
        ["modified_by"]=>
        string(2) "19"
        ["modified_date"]=>
        string(19) "2021-01-19 11:46:10"
        ["modified_ip"]=>
        string(15) "220.241.212.216"
        ["approved_by"]=>
        NULL
        ["approved_date"]=>
        NULL
        ["approved_ip"]=>
        NULL
        ["submitted_by"]=>
        string(2) "24"
        ["submitted_date"]=>
        string(19) "2021-01-19 22:00:55"
        ["submitted_ip"]=>
        string(14) "113.254.229.33"
        ["commited"]=>
        string(1) "1"
        ["approval_status"]=>
        string(1) "3"
        ["active"]=>
        string(1) "1"
        ["deleted"]=>
        string(1) "0"
      }
      [1]=>
      array(41) {
        ["row_num"]=>
        string(1) "2"
        ["uid"]=>
        string(5) "13954"
        ["master_id"]=>
        string(3) "440"
        ["locale"]=>
        string(2) "en"
        ["ranking"]=>
        string(1) "3"
        ["display_date"]=>
        string(19) "2021-01-19 00:00:00"
        ["store"]=>
        string(3) "cwb"
        ["title"]=>
        string(39) "A Bountiful New Year Promotion Campaign"
        ["event_period"]=>
        string(14) "20/1-11/2/2021"
        ["template"]=>
        string(1) "1"
        ["description"]=>
        string(0) ""
        ["pdf"]=>
        string(0) ""
        ["url_name"]=>
        string(0) ""
        ["happening"]=>
        string(1) "1"
        ["highlight"]=>
        string(1) "1"
        ["show_at_index"]=>
        string(1) "1"
        ["thumbnail"]=>
        string(91) "/uploads/images/mainsite/event%26promotion/original_image/20210119/C4_200121_CNY_LD_376.jpg"
        ["thumb_alt"]=>
        string(0) ""
        ["index_image"]=>
        string(88) "/uploads/images/mainsite/event%26promotion/original_image/20210119/200121_CNY_188_v2.jpg"
        ["index_alt"]=>
        string(0) ""
        ["link"]=>
        string(0) ""
        ["popup_type"]=>
        string(1) "1"
        ["happening_end_date"]=>
        string(19) "2021-02-22 00:00:00"
        ["extracted_pdf"]=>
        string(1) "0"
        ["version"]=>
        string(1) "2"
        ["created_by"]=>
        string(2) "19"
        ["created_date"]=>
        string(19) "2021-01-19 17:13:16"
        ["created_ip"]=>
        string(15) "220.241.212.216"
        ["modified_by"]=>
        string(2) "19"
        ["modified_date"]=>
        string(19) "2021-01-19 17:13:56"
        ["modified_ip"]=>
        string(15) "220.241.212.216"
        ["approved_by"]=>
        NULL
        ["approved_date"]=>
        NULL
        ["approved_ip"]=>
        NULL
        ["submitted_by"]=>
        string(2) "24"
        ["submitted_date"]=>
        string(19) "2021-01-19 22:00:48"
        ["submitted_ip"]=>
        string(14) "113.254.229.33"
        ["commited"]=>
        string(1) "1"
        ["approval_status"]=>
        string(1) "3"
        ["active"]=>
        string(1) "1"
        ["deleted"]=>
        string(1) "0"
      }
      [2]=>
      array(41) {
        ["row_num"]=>
        string(1) "3"
        ["uid"]=>
        string(5) "13939"
        ["master_id"]=>
        string(3) "407"
        ["locale"]=>
        string(2) "en"
        ["ranking"]=>
        string(1) "4"
        ["display_date"]=>
        string(19) "2021-01-12 00:00:00"
        ["store"]=>
        string(3) "cwb"
        ["title"]=>
        string(27) "Ladies' Fashion Bazaar Sale"
        ["event_period"]=>
        string(14) "20/1-25/1/2021"
        ["template"]=>
        string(1) "1"
        ["description"]=>
        string(0) ""
        ["pdf"]=>
        string(0) ""
        ["url_name"]=>
        string(0) ""
        ["happening"]=>
        string(1) "1"
        ["highlight"]=>
        string(1) "1"
        ["show_at_index"]=>
        string(1) "1"
        ["thumbnail"]=>
        string(85) "/uploads/images/mainsite/event%26promotion/original_image/20210119/200121_16F_376.jpg"
        ["thumb_alt"]=>
        string(0) ""
        ["index_image"]=>
        string(85) "/uploads/images/mainsite/event%26promotion/original_image/20210119/200121_16F_188.jpg"
        ["index_alt"]=>
        string(0) ""
        ["link"]=>
        string(0) ""
        ["popup_type"]=>
        string(1) "1"
        ["happening_end_date"]=>
        string(19) "2021-01-26 00:00:00"
        ["extracted_pdf"]=>
        string(1) "0"
        ["version"]=>
        string(2) "69"
        ["created_by"]=>
        string(2) "19"
        ["created_date"]=>
        string(19) "2020-03-20 09:55:12"
        ["created_ip"]=>
        string(15) "220.241.212.216"
        ["modified_by"]=>
        string(2) "19"
        ["modified_date"]=>
        string(19) "2021-01-19 12:11:47"
        ["modified_ip"]=>
        string(15) "220.241.212.216"
        ["approved_by"]=>
        NULL
        ["approved_date"]=>
        NULL
        ["approved_ip"]=>
        NULL
        ["submitted_by"]=>
        string(2) "24"
        ["submitted_date"]=>
        string(19) "2021-01-19 22:00:55"
        ["submitted_ip"]=>
        string(14) "113.254.229.33"
        ["commited"]=>
        string(1) "1"
        ["approval_status"]=>
        string(1) "3"
        ["active"]=>
        string(1) "1"
        ["deleted"]=>
        string(1) "0"
      }
      [3]=>
      array(41) {
        ["row_num"]=>
        string(1) "4"
        ["uid"]=>
        string(5) "13945"
        ["master_id"]=>
        string(1) "4"
        ["locale"]=>
        string(2) "en"
        ["ranking"]=>
        string(1) "5"
        ["display_date"]=>
        string(19) "2021-01-12 00:00:00"
        ["store"]=>
        string(3) "cwb"
        ["title"]=>
        string(33) "Kids Fashion & Babies Goods Sale "
        ["event_period"]=>
        string(14) "20/1-25/1/2021"
        ["template"]=>
        string(1) "1"
        ["description"]=>
        string(0) ""
        ["pdf"]=>
        string(0) ""
        ["url_name"]=>
        string(0) ""
        ["happening"]=>
        string(1) "1"
        ["highlight"]=>
        string(1) "1"
        ["show_at_index"]=>
        string(1) "1"
        ["thumbnail"]=>
        string(86) "/uploads/images/mainsite/event%26promotion/original_image/20210119/07_2021_21F_376.jpg"
        ["thumb_alt"]=>
        string(13) "21/F Ballroom"
        ["index_image"]=>
        string(85) "/uploads/images/mainsite/event%26promotion/original_image/20210119/200121_21F_188.jpg"
        ["index_alt"]=>
        string(13) "21/F Ballroom"
        ["link"]=>
        string(68) "http://www.sogo.com.hk/cwb/en/thankfulweek/site/index.php?section=54"
        ["popup_type"]=>
        string(1) "2"
        ["happening_end_date"]=>
        string(19) "2021-01-26 00:00:00"
        ["extracted_pdf"]=>
        string(1) "0"
        ["version"]=>
        string(3) "436"
        ["created_by"]=>
        string(1) "1"
        ["created_date"]=>
        string(19) "2014-05-07 14:59:32"
        ["created_ip"]=>
        string(9) "127.0.0.1"
        ["modified_by"]=>
        string(2) "19"
        ["modified_date"]=>
        string(19) "2021-01-19 12:26:26"
        ["modified_ip"]=>
        string(15) "220.241.212.216"
        ["approved_by"]=>
        NULL
        ["approved_date"]=>
        NULL
        ["approved_ip"]=>
        NULL
        ["submitted_by"]=>
        string(2) "24"
        ["submitted_date"]=>
        string(19) "2021-01-19 22:00:55"
        ["submitted_ip"]=>
        string(14) "113.254.229.33"
        ["commited"]=>
        string(1) "1"
        ["approval_status"]=>
        string(1) "3"
        ["active"]=>
        string(1) "1"
        ["deleted"]=>
        string(1) "0"
      }
    }
  }
  ["sql"]=>
  string(836) "
				SELECT * FROM (
					
				SELECT
					@row:=@row+1 as row_num, promotion.*
				FROM ms_promotion_master promotion
				INNER JOIN (
					SELECT master_id, max(version) currentVersion, commited FROM ms_promotion_master
					WHERE commited = 1
					GROUP BY master_id
				) versioning ON
					versioning.master_id = promotion.master_id
					AND versioning.currentVersion = promotion.version
				INNER JOIN (select @row:=0)r
				WHERE
					promotion.locale = :LOCALE AND
					promotion.active = 1 AND
					promotion.deleted = 0
					AND promotion.store = :store AND
					promotion.display_date <= NOW() AND
					highlight = :HIGHLIGHT AND
					template <> :TEMPLATE
				 ORDER BY ranking ASC, display_date DESC
			
				) RS
				WHERE row_num BETWEEN :START_RECORD AND :END_RECORD
				ORDER BY row_num ASC
			"
  ["dbParam"]=>
  array(6) {
    [0]=>
    array(2) {
      ["name"]=>
      string(7) ":LOCALE"
      ["value"]=>
      string(2) "en"
    }
    [1]=>
    array(2) {
      ["name"]=>
      string(6) ":store"
      ["value"]=>
      string(3) "cwb"
    }
    [2]=>
    array(2) {
      ["name"]=>
      string(10) ":HIGHLIGHT"
      ["value"]=>
      int(1)
    }
    [3]=>
    array(2) {
      ["name"]=>
      string(9) ":TEMPLATE"
      ["value"]=>
      int(4)
    }
    [4]=>
    array(2) {
      ["name"]=>
      string(13) ":START_RECORD"
      ["value"]=>
      int(1)
    }
    [5]=>
    array(2) {
      ["name"]=>
      string(11) ":END_RECORD"
      ["value"]=>
      int(4)
    }
  }
}
SOGO
SOGO Tsim Sha Tsui
繁 | Home
Caring Company 2018/2019
繁
ABOUT SOGOABOUT SOGO ABOUT US LOCATION & TRANSPORTATION SHOPPING DIRECTORYSHOPPING DIRECTORY SHOP LIST FLOOR PLAN NEW SHOPS EVENTS &amp; PROMOTIONSEVENTS & PROMOTIONS CUSTOMER SERVICESCUSTOMER SERVICES CUSTOMER SERVICESLINKS CUSTOMER SERVICESSOGO Tsim Sha Tsui

MENU
繁 | Home
Caring Company 2018/2019

EVENTS & PROMOTIONS

2021 2020 2019 2018

Highlights

= Happenings

SOGO Weekly News
20/1-26/1/2021

A Bountiful New Year Promotion Campaign
20/1-11/2/2021

Ladies' Fashion Bazaar Sale
20/1-25/1/2021
21/F Ballroom

Kids Fashion & Babies Goods Sale

20/1-25/1/2021

December

Christmas Wonderland Bingo! Extra Bonus Prize

5/12-30/12/2018

Christmas Around the Luxury World

12/12-26/12/2018

October

Live in Pink

SOGO VIP Shopping Week Lucky Draw Winner List

28/9-7/10/2018

September

Men's Fashion Week

July

Summer Beauty Passion

20/7-29/7/2018

SOGO Rewards Point Expiry Reminder

1/7-30/9/18

June

The Safari Summer

27/6-31/8/2018

Incredible Dad!

15/6-15/7/2018

My Loved One Dad!

6/6-17/6/2018

Soccer Fever!

13/6-15/7/2018

April

5/F Men's Fashion Week

11/4-1/5/2018

Freshmart 1st Anniversary

11/4-24/4/2018

March

SOGO Rewards Golden Year of the Dog Lucky Draw Winner List

17/1-20/2/2018

Italian Fair

21/3-27/3/2018

Cherry Blossom @ SOGO Beauty

16/3-25/3/2018

4/F Sports Department Renovation

20/3-24/4/2018

February

SOGO Rewards

January

崇光賀年美食迎新歲

17/1-20/2/2018

Love Journey a Valentine Story

31/1-14/2/2018

Happy New Year

9/F-SOGO CLUB 13/F
Disclaimer | Sitemap | Contact Us | Links | Privacy Policy | Copyright © 2021 SOGO Hong Kong Co. Ltd. All Right Reserved.