array(4) {
  ["hasError"]=>
  bool(false)
  ["ResponseObj"]=>
  array(1) {
    ["Items"]=>
    array(4) {
      [0]=>
      array(41) {
        ["row_num"]=>
        string(1) "1"
        ["uid"]=>
        string(5) "11722"
        ["master_id"]=>
        string(3) "388"
        ["locale"]=>
        string(2) "en"
        ["ranking"]=>
        string(1) "1"
        ["display_date"]=>
        string(19) "2019-10-08 00:00:00"
        ["store"]=>
        string(3) "tst"
        ["title"]=>
        string(16) "SOGO Weekly News"
        ["event_period"]=>
        string(16) "11/12-17/12/2019"
        ["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/20191210/111219_TST_SN_376.jpg"
        ["thumb_alt"]=>
        string(16) "SOGO Weekly News"
        ["index_image"]=>
        string(72) "/uploads/images/mainsite/event%26promotion/theme201911/Sogo_News_TST.jpg"
        ["index_alt"]=>
        string(16) "SOGO Weekly News"
        ["link"]=>
        string(0) ""
        ["popup_type"]=>
        string(1) "1"
        ["happening_end_date"]=>
        string(19) "2019-12-31 00:00:00"
        ["extracted_pdf"]=>
        string(1) "0"
        ["version"]=>
        string(2) "11"
        ["created_by"]=>
        string(2) "19"
        ["created_date"]=>
        string(19) "2019-10-08 15:28:29"
        ["created_ip"]=>
        string(15) "220.241.212.216"
        ["modified_by"]=>
        string(2) "19"
        ["modified_date"]=>
        string(19) "2019-12-10 16:21:28"
        ["modified_ip"]=>
        string(15) "220.241.212.216"
        ["approved_by"]=>
        NULL
        ["approved_date"]=>
        NULL
        ["approved_ip"]=>
        NULL
        ["submitted_by"]=>
        string(2) "20"
        ["submitted_date"]=>
        string(19) "2019-12-10 22:01:52"
        ["submitted_ip"]=>
        string(12) "112.118.3.92"
        ["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) "11212"
        ["master_id"]=>
        string(2) "65"
        ["locale"]=>
        string(2) "en"
        ["ranking"]=>
        string(1) "1"
        ["display_date"]=>
        string(19) "2019-05-26 00:00:00"
        ["store"]=>
        string(3) "tst"
        ["title"]=>
        string(17) "SOGO Rewards Days"
        ["event_period"]=>
        string(14) "27/9-6/10/2019"
        ["template"]=>
        string(1) "2"
        ["description"]=>
        string(743) "Please click HERE for details of SOGO Rewards Days.

From 27/9 until 6/10, SOGO Rewards members can enjoy below privileges:

Trade Promotion Competition License No.: 52631, 52632



 "
        ["pdf"]=>
        string(0) ""
        ["url_name"]=>
        string(0) ""
        ["happening"]=>
        string(1) "1"
        ["highlight"]=>
        string(1) "1"
        ["show_at_index"]=>
        string(1) "0"
        ["thumbnail"]=>
        string(111) "/uploads/images/mainsite/event%26promotion/original_image/20190924/sogo%20rewards%20day%20small%20final-376.jpg"
        ["thumb_alt"]=>
        string(17) "SOGO Rewards Days"
        ["index_image"]=>
        string(110) "/uploads/images/mainsite/event%26promotion/original_image/20190924/sogo%20rewards%20day%20small%20final-02.jpg"
        ["index_alt"]=>
        string(17) "SOGO Rewards Days"
        ["link"]=>
        string(26) "https://sogohkcampaign.com"
        ["popup_type"]=>
        string(1) "1"
        ["happening_end_date"]=>
        string(19) "2029-06-01 00:00:00"
        ["extracted_pdf"]=>
        string(1) "0"
        ["version"]=>
        string(3) "302"
        ["created_by"]=>
        string(1) "1"
        ["created_date"]=>
        string(19) "2014-12-16 17:26:26"
        ["created_ip"]=>
        string(9) "127.0.0.1"
        ["modified_by"]=>
        string(1) "1"
        ["modified_date"]=>
        string(19) "2019-09-26 20:27:48"
        ["modified_ip"]=>
        string(15) "220.241.212.216"
        ["approved_by"]=>
        NULL
        ["approved_date"]=>
        NULL
        ["approved_ip"]=>
        NULL
        ["submitted_by"]=>
        string(1) "1"
        ["submitted_date"]=>
        string(19) "2019-09-26 20:28:30"
        ["submitted_ip"]=>
        string(15) "220.241.212.216"
        ["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) "11353"
        ["master_id"]=>
        string(3) "385"
        ["locale"]=>
        string(2) "en"
        ["ranking"]=>
        string(1) "4"
        ["display_date"]=>
        string(19) "2019-10-04 00:00:00"
        ["store"]=>
        string(3) "tst"
        ["title"]=>
        string(12) "Live In Pink"
        ["event_period"]=>
        string(15) "7/10-29/10/2019"
        ["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(119) "/uploads/images/mainsite/event%26promotion/original_image/20191008/071019_WholeStore_Live%20in%20Pink_web_thumbnail.jpg"
        ["thumb_alt"]=>
        string(0) ""
        ["index_image"]=>
        string(114) "/uploads/images/mainsite/event%26promotion/original_image/20191008/071019_Live%20in%20Pink_web%20icon_314x188p.jpg"
        ["index_alt"]=>
        string(0) ""
        ["link"]=>
        string(0) ""
        ["popup_type"]=>
        string(1) "1"
        ["happening_end_date"]=>
        string(19) "2019-10-30 00:00:00"
        ["extracted_pdf"]=>
        string(1) "0"
        ["version"]=>
        string(1) "4"
        ["created_by"]=>
        string(2) "19"
        ["created_date"]=>
        string(19) "2019-10-04 11:25:11"
        ["created_ip"]=>
        string(15) "220.241.212.216"
        ["modified_by"]=>
        string(2) "19"
        ["modified_date"]=>
        string(19) "2019-10-08 16:15:02"
        ["modified_ip"]=>
        string(15) "220.241.212.216"
        ["approved_by"]=>
        NULL
        ["approved_date"]=>
        NULL
        ["approved_ip"]=>
        NULL
        ["submitted_by"]=>
        string(2) "20"
        ["submitted_date"]=>
        string(19) "2019-10-08 16:30:02"
        ["submitted_ip"]=>
        string(15) "220.241.212.216"
        ["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) "11242"
        ["master_id"]=>
        string(3) "377"
        ["locale"]=>
        string(2) "en"
        ["ranking"]=>
        string(1) "4"
        ["display_date"]=>
        string(19) "2019-09-03 00:00:00"
        ["store"]=>
        string(3) "tst"
        ["title"]=>
        string(44) "Autumn Surprise Grand Lucky Game Winner List"
        ["event_period"]=>
        string(13) "4/9-26/9/2019"
        ["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(122) "/uploads/images/mainsite/event%26promotion/original_image/20190930/Autumn%20Surprise%20Winner%20List%20thumbnail-01-01.jpg"
        ["thumb_alt"]=>
        string(0) ""
        ["index_image"]=>
        string(123) "/uploads/images/mainsite/event%26promotion/original_image/20190930/Autumn%20Surprise%20Winner%20List%20thumbnail-314-02.jpg"
        ["index_alt"]=>
        string(0) ""
        ["link"]=>
        string(0) ""
        ["popup_type"]=>
        string(1) "1"
        ["happening_end_date"]=>
        string(19) "2019-11-05 00:00:00"
        ["extracted_pdf"]=>
        string(1) "0"
        ["version"]=>
        string(1) "7"
        ["created_by"]=>
        string(2) "19"
        ["created_date"]=>
        string(19) "2019-08-30 12:37:42"
        ["created_ip"]=>
        string(15) "220.241.212.216"
        ["modified_by"]=>
        string(2) "19"
        ["modified_date"]=>
        string(19) "2019-10-03 18:11:02"
        ["modified_ip"]=>
        string(15) "220.241.212.216"
        ["approved_by"]=>
        NULL
        ["approved_date"]=>
        NULL
        ["approved_ip"]=>
        NULL
        ["submitted_by"]=>
        string(2) "20"
        ["submitted_date"]=>
        string(19) "2019-10-04 09:41:51"
        ["submitted_ip"]=>
        string(15) "220.241.212.216"
        ["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) "tst"
    }
    [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 Causeway Bay
繁 | 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 Causeway Bay

MENU
繁 | Home
Caring Company 2018/2019

EVENTS & PROMOTIONS

2019 2018 2017

Highlights

= Happenings

SOGO Weekly News

SOGO Weekly News
11/12-17/12/2019
SOGO Rewards Days

SOGO Rewards Days
27/9-6/10/2019

Live In Pink
7/10-29/10/2019

Autumn Surprise Grand Lucky Game Winner List
4/9-26/9/2019

October

SOGO Beauty Season Of Love

11/10-20/10

April

SOGO VIP Shopping Week Lucky Draw Winner List

29/3-7/4/2019

March

SOGO Rewards Golden Year of the Pig Lucky Draw Winner List

9/1-19/2/2019

February

SOGO Hong Kong x SOGO Japan & Seibu Japan Special Promotion

January

SOGO Chinese New Year Food Fair

16/1-12/2/2019
Disclaimer | Sitemap | Contact Us | Links | Privacy Policy | Copyright © 2019 SOGO Hong Kong Co. Ltd. All Right Reserved.