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 dtb_products AS p
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-05-01 18:16:07')
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 15360, 120
54665 MISHKA(ミシカ) MSS203224 BUCKET HAT
54667 MISHKA(ミシカ) MSS203213 CAP BLACK
54668 MISHKA(ミシカ) MSS203209 CAP
54703 MISHKA MSS200005 T-SHIRTS GREEN
54704 MISHKA MSS200005 T-SHIRTS ORANGE
54705 ROLLING CRADLE CHERRY HAT
54706 ROLLING CRADLE CHERRY TOTE
54707 MISHKA (ミシカ) KUMARA TEE
54708 MISHKA (ミシカ) BUTIGER TEE
54709 MISHKA (ミシカ) KUMARA HOODIE
54710 MISHKA (ミシカ) BUTIGER HOODIE
53248 Zephyren(ゼファレン)PONCHO BIG STRIPE TEE S/S WHITE/BLACK
54648 RUDIE'S (ルーディーズ) SOLID PHAT GRADATION-T BLACK
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
52941 Survive Said The Prophet VERTICAL LOGO TEE
52952 Survive Said The Prophet FIRE LOGO CAP
54614 Survive Said The Prophet INSIDE YOUR HEAD TEE BLACK
54616 Survive Said The Prophet TAPED LOGO TEE BLACK
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
54451 MISHKA(ミシカ) MSS200906 SHORTS
54076 RUDIE'S (ルーディーズ) TUSK OPEN COLLAR SHIRTS BLACK
54078 RUDIE'S (ルーディーズ) TUSK SHORTS BLACK
53882 MISHKA(ミシカ) MSS200874 PANTS
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
53132 RUDIE'S TUSK WAISTBAG BLACK
52995 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO (BACK PRINT)
52942 Survive Said The Prophet MIA TOUR TEE
52948 Survive Said The Prophet UNBALANCE TEE LIGHT BLUE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
52951 Survive Said The Prophet UNBALANCE TEE YELLOW
52953 Survive Said The Prophet EVERY DAY SOX A
52696 CIVARIZE "Loser" , Coated hoodie
34943 SABBAT13 REAPER SWING TOP JKT (ブラック) BLACK
39461 PARADOX – SWITCHING PULLOVER BLOUSON WHITE
39512 SABBAT13 PATCH MILITARY BIG JKT (BK)
45564 GALFY 色絶妙ナイロンジャケット BLACK
52462 GALFY (ガルフィー) 犬パーカー 黒
52447 STAPLE Neo Sport Nylon Crew
52438 SABBAT13 PARADISE HOODIE(ブラック)
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
51493 NieR (ニーア) ポケット付総柄ペイント半袖パーカー
51154 SLEEPING TABLET×火寺バジル(魔法少女になり隊)コラボ・Tシャツ BLACK
37117 SILLENT FROM ME RUBRIC -Crew Sweat- BLACK
8059 KILL STAR CLOTHING METAL T-SHIRT [B]
9419 WE CAME AS ROMANS Truth Black T-Shirt
11582 KILL STAR CLOTHING LUCIFER TANK [B]
12976 HOLYSHITz Hexagram T-shirts sumi
22892 Zephyren (ゼファレン) THRASHER x Zephyren S/S TEE -PENETRATE- BLACK
29535 CARCASS UNFIT TEE
34389 PUNK DRUNKERS 【PDSxTREST】TPU iPhone case(STAR PKDS)
35286 SLIPKNOT Long Sleeved Tee: Blocks
35392 Zephyren (ゼファレン) BIG S/S TEE -ENGRAVE- BLACKxWHITE
39172 KORN Face in the Fire Tanktop
40180 Zephyren BANDANA SHORTS BLACK
40647 MISHKA SP181303 FLYING TIGER KEEP WATCH TEE BLACK
45484 TOY MACHINE TMS19ST17 SECT PROTOP PRINT SS TEE BLACK
46151 Subciety (サブサエティ) WORK SHIRT-Primal- BLACK
46341 Zephyren(ゼファレン)S/S TEE - alea iacta est / milestone - BLACK
46450 Zephyren(ゼファレン)BIG TANKTOP BLACK / 如意宝珠
47524 VIRGO VG-CUT-381 VINTAGE RAGLAN CUTSEW 染めカットソー BLACK
48688 Zephyren(ゼファレン) LONG SHIRT L/S BLACK / 如意宝珠
49941 DI:VISION “EPHEMERAL” L/S TEE BLACK
51193 SLIPKNOT UNISEX FASHION TEE: LOGO & STAR (APPLIQUE MOTIFS)
51390 KAVANE Clothing "criticize"Long Sleeve(Red)
52001 Zephyren(ゼファレン) S/S TEE -BEYOND- D.GREEN/WHITE
54330 Subciety (サブサエティ) SKINNY PANTS BLACK
54644 THRASHER TH91257 JAN 82 S/S T-SHIRTS
55658 MISHKA (ミシカ) KEEP WATCH SWIM SHORTS
16679 【ゲキクロ限定カラー】lynch. ツアーTシャツ BLUE
16682 【ゲキクロ限定カラー】lynch. ツアーTシャツ GRAY
54643 THRASHER TH8177A S.A.D Tee BLACK
14355 FAMOUS STARS AND STRAPS DESTROYER Mens Snap Fleece
35482 Zephyren (ゼファレン) SWEAT -PORTAL- BLACK
35835 Zephyren (ゼファレン) BIG JAGUARD KNIT -Cut the world- BLACK
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress
51291 ROLLING CRADLE FLEECE JACKET / Black