Notes

SELECT
pl.pd_id AS productId,
p.pd_code AS skuKey,
CASE
WHEN pl.lang_type_id = 2 THEN 'id'
ELSE 'eng'
END AS lang,
pl.pd_shortdesc AS `desc`,
'' AS seo,
CONCAT(pl.pd_desc, '<br/><br/>', pl.pd_info) AS details,
'MIGRATE' AS createdBy,
NOW() AS createdAt,
'MIGRATE' AS updatedBy,
NOW() AS updatedAt
FROM product_language pl
LEFT JOIN product p ON p.pd_id = pl.pd_id
WHERE
p.pd_code NOT IN (
'BagMini-New', 'ROK-NEW', 'LEG-004-01', '613T-04-New', 'MINI BAGS-NEW', 'F-30', 'na', '040612', '090712', '110912', '150512',
'313T', '313T-01-20', '313T-09-20', '912B-01-Tenun Ikat-NEW','912B-01','912B-01-01','912B-01-Batik','912B-01-IKAT','912B-01-NEW',
'912B-01-Tenun Ikat-NEW','912B-02','C-01','C-104','C-17','C-23','C-53','BX-03','BXL-03','BXL-128','wedges','Tie-Dye-NEW','TieDye',
'Boxy Long','Boxy Long Acid','Boxy Pima','Faith','Flats-32','Jupiter Knee','Jupiter Maxi','Leggings Watercolor','M12B-01','AC-22',
'CIB-003','APT-05-19','1013T-04-Brokat-NEW','3D Cardigan','413T-01','512A-03-119','512T-17','512T-17-02','613A-01','613A-01-01',
'613A-01-20','613A-01-21','613A-01-JacketNTT','613A-01-Maroon','613A-01-NTT-NEW','613B-02-20','613T-30-Boxy Ikat-NEW','813B-02',
'813B-03-Tenun','813T-06-NEW','M12B-01-01','M12B-01-09','M12B-01-20','M12T-02-01','M12T-04-11','M12T-04-31','M12T-07-126','M12T-15',
'Neptune Knee','Neptune Maxi','OA-009','OA-010','OA-011','Ombre','PO 15/08','SAO-003-108','SC-LG','TAS MINI-NEW','UTI-01','W11C-04',
'W11T-02-04','C-119','313T-05','0111BA-12-03','0111BA-83-02','0119SO-19-00','0119SO-20-00','0311SC-46-12','0415SD-06-20','0415SD-14-01',
'0514LP-17-06','0912LP-43-05','0915SS-38-10','1611TT-60-15'
)
AND UPPER(p.pd_code) NOT LIKE UPPER('%bag%')
AND UPPER(p.pd_code) NOT LIKE UPPER('%bags%')
AND UPPER(p.pd_code) NOT LIKE UPPER('%dummy%')
AND UPPER(p.pd_code) NOT LIKE UPPER('%sample%')
AND UPPER(p.pd_code) NOT LIKE UPPER('%lama%')
AND UPPER(p.pd_code) NOT LIKE UPPER('%.%')
AND p.pd_code != ''
AND p.pd_is_delete = 0
AND p.color_id >= 41
ORDER BY pl.pd_lang_id DESC;




wedges
-- ====================== ============================= ===============================

SELECT
pd_code,
COUNT(pd_code)
FROM
product
WHERE
pd_code NOT IN (
'BagMini-New', 'ROK-NEW', 'LEG-004-01', '613T-04-New', 'MINI BAGS-NEW', 'F-30', 'na', '040612', '090712', '110912', '150512',
'313T', '313T-01-20', '313T-09-20', '912B-01-Tenun Ikat-NEW','912B-01','912B-01-01','912B-01-Batik','912B-01-IKAT','912B-01-NEW',
'912B-01-Tenun Ikat-NEW','912B-02','C-01','C-104','C-17','C-23','C-53','BX-03','BXL-03','BXL-128','wedges','Tie-Dye-NEW','TieDye',
'Boxy Long','Boxy Long Acid','Boxy Pima','Faith','Flats-32','Jupiter Knee','Jupiter Maxi','Leggings Watercolor','M12B-01','AC-22',
'CIB-003','APT-05-19','1013T-04-Brokat-NEW','3D Cardigan','413T-01','512A-03-119','512T-17','512T-17-02','613A-01','613A-01-01',
'613A-01-20','613A-01-21','613A-01-JacketNTT','613A-01-Maroon','613A-01-NTT-NEW','613B-02-20','613T-30-Boxy Ikat-NEW','813B-02',
'813B-03-Tenun','813T-06-NEW','M12B-01-01','M12B-01-09','M12B-01-20','M12T-02-01','M12T-04-11','M12T-04-31','M12T-07-126','M12T-15',
'Neptune Knee','Neptune Maxi','OA-009','OA-010','OA-011','Ombre','PO 15/08','SAO-003-108','SC-LG','TAS MINI-NEW','UTI-01','W11C-04',
'W11T-02-04','C-119','313T-05','0111BA-12-03','0111BA-83-02','0119SO-19-00','0119SO-20-00','0311SC-46-12','0415SD-06-20','0415SD-14-01',
'0514LP-17-06','0912LP-43-05','0915SS-38-10','1611TT-60-15'
)
AND UPPER(pd_code) NOT LIKE UPPER('%bag%')
AND UPPER(pd_code) NOT LIKE UPPER('%bags%')
AND UPPER(pd_code) NOT LIKE UPPER('%dummy%')
AND UPPER(pd_code) NOT LIKE UPPER('%sample%')
AND UPPER(pd_code) NOT LIKE UPPER('%lama%')
AND UPPER(pd_code) NOT LIKE UPPER('%.%')
AND pd_code != ''
AND pd_is_delete = 0
AND color_id >= 41
GROUP BY pd_code
HAVING COUNT(pd_code) > 1
ORDER BY pd_code DESC
;sap



SELECT
p.*
-- p.pd_code,
-- subcategory.sub_name,
-- product_stock.is_main
FROM product p
-- LEFT JOIN subcategory ON subcategory.sub_id = p.sub_id
-- LEFT JOIN product_stock ON product_stock.pd_id = p.pd_id
WHERE
p.pd_code IN (
'0915SS-24-AB','0915LS-23-AA','0915JA-26-AA','0713LP-01-03','0616SD-48-02','0613LS-43-AA','0613LS-36-01','0613LS-02-02','0416SL-05-STA',
'0416LS-02-02','0416LD-65-01','0414LP-21-02','0316SS-61-STA','0316SS-04-10','0316SD-32-05','0316SD-32-02','0316SD-16-01','0213LS-33-02',
'0111BA-08-01'
)
AND p.pd_is_delete = 0
AND p.color_id >= 41
ORDER BY
pd_code DESC
;