Old website update package
{
"code": "9999234",
"description": "KRISMIS",
"full_description": "KRISMIS",
"products": "11477,11943,12525,12527,12528,12530,12756,14071,14218,14989,15254,16583,16610,16661,16662,17143,17416,17466,17494,17655,18138,18227,18346,18414,18464,18585,18997,19015,19045,19086,19394,19424,19432,19434,19435,19438,19458,19476,19511,19529,19534,19603,19608,19615,19617,19633,19640,19675,19693,19697,19803,19902,20018,20038,20045,20094,20129,20162,20165,20172,20178,20197,20241,20300,20316,20363,20381,20487,20501,20519,20539,20542,20554,20569,20573,20583,20665,20742,20756,20816,20942,20978,20982,20993,21060,21073,21252,21257,21314,21346,21348,21365,21372,21382,21384,21385,21386,21387,21388,21389,21390,21391,21395,21397,21403,21404,21414,21456,21457,21458,21459,21460,21461,21462,21463,21464,21465,21466,21467,21468,21469,21470,21471,21472,21473,2178,9882,9883,9885",
"start_date": "2022-11-21",
"end_Date": "2023-01-12"
}
Extract sql:
SELECT
'9999234' AS `code`,
'KRISMIS' AS `description`,
'KRISMIS' AS `full_description`,
GROUP_CONCAT(pr_productcode) AS `products`,
str_to_date(ph_startdate,'%d.%m.%Y') AS start_date,
str_to_date(ph_enddate,'%d.%m.%Y') AS end_Date
FROM promotion_header AS a
LEFT JOIN promotion_detail AS b ON a.PH_ID=b.PR_ID
WHERE ph_id='234'