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 =588
)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-05-27 03:49:39')
AND pc.price02 > 13636
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 60
53074 SAMURAI CORE 釈迦 HOODIE BLACK
55635 Anti Social Social Club MIND GAMES BLACK HOODIE
56896 Anti Social Social Club FOOD COURT BLACK HOODIE
56936 SLEEPING TABLET WOOLY [ SUSPEND ANORAK ] BLACK
58058 NOT COMMON SENSE NCS FLAME HOODIE BLACK
58100 WASTED PARIS Hoodie Columbia Bridge Black
58110 MISHKA M21000404 Pullover BLACK
58450 Subciety (サブサエティ)×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA BLACK
59312 Anti Social Social Club A Fire Inside Black Hoodie - Flame
60412 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE BLACK
60508 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE NAVY
61277 LONELY論理 CHRYSANTHEMUM HOODIE BLACK
61284 LONELY論理 KAMIKAZE HOODIE BLACK
60161 Anti Social Social Club I SEE BLUE SPLASH BLACK HOODIE
60162 Anti Social Social Club I SEE PINK SPLASH BLACK HOODIE
60813 ROLLING CRADLE COSPLAY GIRL-THUNDER- HOODIE / BLACK
61569 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE BLACK
61441 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie Black
61837 Subciety (サブサエティ) EMBROIDERY PARKA BLACK
61838 Subciety (サブサエティ) EMBROIDERY PARKA BLACK/BLACK
61846 A FEW GOOD KIDS EARTH ON THE HOODIE BLACK
62634 LONELY論理 NAMENJYANEYO SCHOOL GIRL HOODIE BLACK
63000 SUPPLIER (サプライヤー) PLAYBOY ALL OVER EMBROIDERY PULLOVER BLACK
63102 CIVARIZE【シヴァーライズ】オーバーサイズインクジェットプルオーバーパーカー MONOTONE
63101 CIVARIZE【シヴァーライズ】オーバーサイズインクジェットプルオーバーパーカー COLOR
62773 ROLLING CRADLE CNS HOODIE / BLACK
63378 Anti Social Social Club Self Conclusion Black Hoodie
65710 LONELY論理 SLAYER V HOODIE-BLACK
65712 LONELY論理 GREAT SEXUAL TEACHER "MAHO" HOODIE-BLACK
66203 ANIMALIA (アニマリア) CUT-OFF HOODIE BLACK
63679 【セット販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! SET UP BLACKタイダイ
61401 NineMicrophones PIGMENT PARKA BLACK
65384 Subciety (サブサエティ) BLEACH PARKA-THE BASE- BLACK
65464 Subciety (サブサエティ) RAGLAN PARKA-BLACK
66676 Subciety (サブサエティ) SIDE BLEACH PARKA BLACK
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
60561 Subciety 2022 福袋 -NEW YEAR BAG-
66786 LONELY論理 RINNE TENSEI HOODIE BLACK
66794 Subciety (サブサエティ) DUCK ANORAK BLACK
66963 PLEASURES(プレジャーズ) REALITY HOODIE BLACK
66473 10-FEET×Zephyren(ゼファレン) BIG PARKA BLACK
66246 glamb(グラム) Himiko Toga Hoodie Black
67880 RIPNDIP (リップンディップ) Heaven On Earth Hoodie Black
69239 THRASHER (スラッシャー) Jake Dish Hoodie BLACK
68526 RIPNDIP (リップンディップ) Shock Hoodie BLACK
69519 SABBAT13(サバトサーティーン) DEATH HAWK HOODIE BLACK
69329 RIPNDIP (リップンディップ) KAWAII NERM HOODIE BLACK
67902 RIPNDIP (リップンディップ) Hypnotic Hoodie (Black/Cream)
68476 RIPNDIP (リップンディップ) Nerminator 2.0 Hoodie BLACK
68475 RIPNDIP (リップンディップ) Peace Love RIPNDIP Hoodie BLACK
69391 Subciety (サブサエティ) PIGMENT PARKA BLACK
57277 Subciety (サブサエティ) PARKA-PROVIDENCE- BLACK
69756 Subciety (サブサエティ) Pieta PARKA BLACK
69996 ANIMALIA (アニマリア) ATTERNED ALL OVER HOODIE : Vintage Flowers BLACK
69180 glamb (グラム) GB0323/CS10 : Cross Stitch Hoodie / クロスステッチフーディ Black
69175 glamb (グラム) GB0323/CS16 : Drape Neck Hoodie / ドレープネックフーディ Black
69028 【ONE PIECE×絡繰魂】 愛と自由 プルパーカー BLACK
68060 プランクスターズ×GALFYコラボ・パーカー BLACK
70214 LONELY論理#28 13oz HEAVYWEIGHT "TANREI" HOODIE BLACK
70103 【予約商品】BLXCK Tokyo(ブラックトーキョー) Extra Damaged Crop Hoodie