SELECT SQL_CALC_FOUND_ROWS 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-04-18 19:28:35')
AND pc.price02 > 13636
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
13803 Subciety TIE DYE ZIP PARKA-EMOTION- GRAY
45577 TOY MACHINE TMP19SW16 FIST EMBRO SWEAT PARKA BLACK
51162 SLEEPING TABLET PATIENT [ HALF BUTTON VELOUR PULLOVER ] NAVY
51240 SAMURAI CORE SR-PK-07-B PUNK侍 pk black
51475 ANIMALIA AN19W-SW02 P/O HOODIE - CONVERT BLACK
53074 SAMURAI CORE 釈迦 HOODIE BLACK
53075 SAMURAI CORE 釈迦 HOODIE WHITE
53076 SAMURAI CORE 釈迦 HOODIE RED
53110 SAMURAI CORE 夜露死苦哀愁 HOODIE BLACK
53112 SAMURAI CORE 夜露死苦哀愁 HOODIE RED
53947 NOT COMMON SENSE ”NCS FILM” HOODIE
55635 Anti Social Social Club MIND GAMES BLACK HOODIE
55629 Anti Social Social Club SAMSIES PINK HOODIE
55628 Anti Social Social Club SAMSIES BLUE HOODIE
56202 Anti Social Social Club True Colors Purple Camo
56206 Anti Social Social Club Don’t Red Hoodie
56896 Anti Social Social Club FOOD COURT BLACK HOODIE
56936 SLEEPING TABLET WOOLY [ SUSPEND ANORAK ] BLACK
50552 FOG ESSENTIALS Pullover Hoodie LIGHT HEATHER
56836 Subcietyx攻殻機動隊 SECTION9 PULLOVER PARKA KHAKI
57351 SUPPLIER (サプライヤー) LOGO HOODIE RED
56458 Subciety (サブサエティ) SOUVENIR PARKA- KHAKI
58056 NOT COMMON SENSE NCS SNAKE HOODIE WHITE
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
58058 NOT COMMON SENSE NCS FLAME HOODIE BLACK
58100 WASTED PARIS Hoodie Columbia Bridge Black
58099 WASTED PARIS Hoodie Columbia Bridge Lilac
58101 WASTED PARIS Hoodie Columbia Bridge Pink
57332 Subciety×仮面ライダードライブ MACH PARKA WHITE
58110 MISHKA M21000404 Pullover BLACK
58109 MISHKA M21000404 Pullover WHITE
58327 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO INDIGO
58328 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO L.BLUE
58450 Subciety (サブサエティ)×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA BLACK
58451 Subciety ×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA GRAY
59312 Anti Social Social Club A Fire Inside Black Hoodie - Flame
59014 Subciety (サブサエティ) PIGMENT PARKA - RED
60412 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE BLACK
60507 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE GRAY
60508 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE NAVY
60766 ROLLING CRADLE LOGO ROSE HOODIE / RED
60814 ROLLING CRADLE COSPLAY GIRL-THUNDER- HOODIE / PINK
61276 LONELY論理 3EMBROIDERY HOODIE GRAY
61277 LONELY論理 CHRYSANTHEMUM HOODIE BLACK
61284 LONELY論理 KAMIKAZE HOODIE BLACK
61285 LONELY論理 KAMIKAZE HOODIE WHITE
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
61568 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE CREAM
61569 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE BLACK
61278 LONELY論理 CHRYSANTHEMUM HOODIE WHITE
61440 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie White
61441 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie Black
61837 Subciety (サブサエティ) EMBROIDERY PARKA BLACK
61838 Subciety (サブサエティ) EMBROIDERY PARKA BLACK/BLACK
61844 A FEW GOOD KIDS EARTH ON THE HOODIE LIGHT PURPLE
61845 A FEW GOOD KIDS EARTH ON THE HOODIE ORANGE
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
63001 SUPPLIER (サプライヤー) PLAYBOY ALL OVER EMBROIDERY PULLOVER BROWN
63102 CIVARIZE【シヴァーライズ】オーバーサイズインクジェットプルオーバーパーカー MONOTONE
63101 CIVARIZE【シヴァーライズ】オーバーサイズインクジェットプルオーバーパーカー COLOR
62773 ROLLING CRADLE CNS HOODIE / BLACK
62774 ROLLING CRADLE CNS HOODIE / YELLOW
63378 Anti Social Social Club Self Conclusion Black Hoodie
63376 Anti Social Social Club Passing Fad Pink Hoodie
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
65710 LONELY論理 SLAYER V HOODIE-BLACK
65712 LONELY論理 GREAT SEXUAL TEACHER "MAHO" HOODIE-BLACK
65711 LONELY論理 SLAYER V HOODIE-WHITE
66204 ANIMALIA (アニマリア) CUT-OFF HOODIE GRAY
66203 ANIMALIA (アニマリア) CUT-OFF HOODIE BLACK
65720 GALFY (ガルフィー) クレイジーわんわん大学 SET UP GREEN×BLUE
66305 幽遊白書×ROLLING CRADLE 集合 HOODIE / BLACK
63679 【セット販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! SET UP BLACKタイダイ
63678 【セット販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! SET UP REDタイダイ
63677 【セット販売】へきトラ劇場×GALFY×GEKIROCK CLOTHING 開店!!!! SET UP GREENタイダイ
61403 NineMicrophones PIGMENT PARKA GREEN
61401 NineMicrophones PIGMENT PARKA BLACK
65382 Subciety (サブサエティ) BLEACH PARKA-THE BASE- GRAY
65383 Subciety (サブサエティ) BLEACH PARKA-THE BASE- PURPLE
65384 Subciety (サブサエティ) BLEACH PARKA-THE BASE- BLACK
65464 Subciety (サブサエティ) RAGLAN PARKA-BLACK
65461 Subciety (サブサエティ) CHENILLE COLLEGE PARKA-GREEN
65491 Subciety (サブサエティ) CHENILLE COLLEGE PARKA-ORANGE
66677 Subciety (サブサエティ) SIDE BLEACH PARKA GREEN
66678 Subciety (サブサエティ) SIDE BLEACH PARKA PURPLE
66676 Subciety (サブサエティ) SIDE BLEACH PARKA BLACK
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
66247 RUDIE'S (ルーディーズ) 2023 福袋 NEWYEAR PACK
60561 Subciety 2022 福袋 -NEW YEAR BAG-
66301 Subciety 2023 福袋 -NEW YEAR BAG-
66786 LONELY論理 RINNE TENSEI HOODIE BLACK
66788 LONELY論理 RINNE TENSEI HOODIE HEATHER
66795 Subciety (サブサエティ) DUCK ANORAK OFF WHITE
66793 Subciety (サブサエティ) DUCK ANORAK CAMEL
66794 Subciety (サブサエティ) DUCK ANORAK BLACK
66963 PLEASURES(プレジャーズ) REALITY HOODIE BLACK
66496 10-FEET×Zephyren(ゼファレン) BIG PARKA OFF WHITE
66473 10-FEET×Zephyren(ゼファレン) BIG PARKA BLACK
66235 glamb(グラム) Himiko Toga Hoodie White
66246 glamb(グラム) Himiko Toga Hoodie Black
67880 RIPNDIP (リップンディップ) Heaven On Earth Hoodie Black
69239 THRASHER (スラッシャー) Jake Dish Hoodie BLACK
69238 THRASHER (スラッシャー) Inferno Hoodie NAVY BLUE
69240 THRASHER (スラッシャー) Outlined Chest Logo Hoodie GRAY
68526 RIPNDIP (リップンディップ) Shock Hoodie BLACK
69521 SABBAT13(サバトサーティーン) DEATH HAWK HOODIE SAND
69520 SABBAT13(サバトサーティーン) DEATH HAWK HOODIE ASH
69519 SABBAT13(サバトサーティーン) DEATH HAWK HOODIE BLACK
69593 RIPNDIP (リップンディップ) SUSHI NERM HOODIE (SANDSTONE)
69329 RIPNDIP (リップンディップ) KAWAII NERM HOODIE BLACK
66856 RIPNDIP (リップンディップ) Ripnlit Hoodie Charcoal Faded Wash
67903 RIPNDIP (リップンディップ) Waves Sherpa Hoodie (Light Slate)
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