SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =96
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2024-04-28 17:19:11')
AND FIND_IN_SET(22, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
68639 PUNK DRUNKERS(パンクドランカーズ)ボンテージ風チェックパンツ - RED CHECK
68640 PUNK DRUNKERS(パンクドランカーズ)ボンテージ風チェックパンツ - YELLOW CHECK
63529 glamb (グラム) Glen Check Balloon Pants - Gray
61271 Zephyren 2022 NEW YEAR BAG
58374 WASTED PARIS Worker Pants Houdstooth Brown
65834 NieR (ニーア) 軽量×ロゴパッチ付きSARROUEL PANTS
62341 Zephyren(ゼファレン) EASY PANTS 8/S CHECK
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
50650 CHORD NUMBER EIGHT CH01-01K5-PL07 SIDE LINE CHECK CROPPED PANTS BLACK&RED
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60456 ROLLING CRADLE CHECK FLARE PANTS / YELLOW
60457 ROLLING CRADLE CHECK FLARE PANTS / BLUE
59672 Zephyren(ゼファレン) EASY PANTS 8/S GREEN CHECK
57583 Zephyren(ゼファレン) EASY PANTS BROWN CHECK
57587 Zephyren(ゼファレン) EASY PANTS 8/S BROWN CHECK
57155 SABBAT13 GHOST CHECK SLACKS GRAY
58484 SILLENT FROM ME LAWYER -Wide Slacks- GRAY CHECK
57156 SABBAT13 GHOST CHECK SLACKS BROWN
56257 SILLENT FROM ME SILLENT FROM ME HARRY -Slim Slacks- GRAY CHECK
56258 SILLENT FROM ME SILLENT FROM ME HARRY -Slim Slacks- BLACK CHECK
40577 VIRGO OBLIQUE CHECK PANTS チェックサルエルパンツ GREEN
41017 SILLENT FROM ME FALLEN -Slacks- CHECK
41356 ROLLING CRADLE WIDE CHECK PANTS / White-Red
41842 MISHKA (ミシカ) MAW180827 PANT Red
45363 ROLLING CRADLE RC CHECKER WIDE PANTS Black
45431 DISTURBIA CLOTHING Sid Trousers
45615 MISHKA MSS190845M00 PANTS
45928 SABBAT13 SBT-PT-007 CHECK UTILITY PANTS (ブラック)
45929 SABBAT13 SBT-PT-007 CHECK UTILITY PANTS (レッド)
45939 NOT COMMON SENSE DOBBY CHECK PANTS D/GREEN CK
45940 NOT COMMON SENSE DOBBY CHECK PANTS PURPLE CK
47715 ROLLING CRADLE CHECK PANTS / Gray
48360 Subciety (サブサエティ) CHECK SLACKS RED
49782 MISHKA MAW190847 PANTS
49783 MISHKA MAW190857 PANTS
49784 MISHKA MAW190870 PANTS
50235 Drug Honey ジップデザインチェック柄ワイドパンツ BLACK
50236 Drug Honey ジップデザインチェック柄ワイドパンツ RED
50322 ROLLING CRADLE RC JOGGER PANTS / Yellow
50457 PUNK DRUNKERS チェケラッチョチェックパンツ BLACK
50459 PUNK DRUNKERS チェケラッチョチェックパンツ BLUE
50529 Zephyren(ゼファレン) SLACKS BLACK / CHECK
50730 SABBAT13 CHILLAXING CHECK PANTS (グリーン)
50731 SABBAT13 CHILLAXING CHECK PANTS (ブラウン)
50815 MUSIC SAVED MY LIFE M101-01K5-PL02 2LINE CHECK PANTS BLACK
50816 MUSIC SAVED MY LIFE M101-01K5-PL02 2LINE CHECK PANTS BEIGE
51139 MISHKA MAW190811 PANTS
51511 MISHKA MSS200855M00 PANTS
51732 SABBAT13 CHILLAXING EASY PANTS (ブラックチェック)
51733 SABBAT13 CHILLAXING EASY PANTS (ベージュチェック)
52676 VIRGO G-PT-324 HANDLE NINJAS GREEN
52677 VIRGO G-PT-324 HANDLE NINJAS BLUE
52742 ROLLING CRADLE CHECK CROPPED PANTS BROWN
52743 ROLLING CRADLE CHECK CROPPED PANTS BLUE
52982 VIRGO VG-PT-229A NOSTALGIC CHECK PANTS BLACK
52983 VIRGO VG-PT-229A NOSTALGIC CHECK PANTS RED
53106 PUNK DRUNKERS チェックx2ラインパンツ NAVY
53107 PUNK DRUNKERS チェックx2ラインパンツ BROWN