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-27 04:17:13')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 360, 120
61341 SLEEPING TABLET TABLETS [ PULLOVER ] BLACK
63101 CIVARIZE【シヴァーライズ】オーバーサイズインクジェットプルオーバーパーカー COLOR
63102 CIVARIZE【シヴァーライズ】オーバーサイズインクジェットプルオーバーパーカー MONOTONE
63086 HYPER CORE 東京羽堕腐蕾-トーキョーバタフライ- フーディー BLUE×PURPLE
63087 HYPER CORE 東京羽堕腐蕾-トーキョーバタフライ- フーディー PINK×MINT
63066 ANIMALIA AN22SP-SW07 DOUBLE KNIT HOODIE-Overlap Logo BLUE
63067 ANIMALIA AN22SP-SW07 DOUBLE KNIT HOODIE-Overlap Logo BLACK
63000 SUPPLIER (サプライヤー) PLAYBOY ALL OVER EMBROIDERY PULLOVER BLACK
63001 SUPPLIER (サプライヤー) PLAYBOY ALL OVER EMBROIDERY PULLOVER BROWN
62634 LONELY論理 NAMENJYANEYO SCHOOL GIRL HOODIE BLACK
62603 HYPER CORE HERE COMES THE PAINフーディー BLACK/BLUE
62570 Survive Said The Prophet REDEFINE TOUR HOODIE BLACK
62571 Survive Said The Prophet REDEFINE TOUR HOODIE WHITE
61823 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: LARGE LOGO & ALBUM
62184 acOlaSia (アコレイジア) GAMING hoodie WHITE
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
61837 Subciety (サブサエティ) EMBROIDERY PARKA BLACK
61838 Subciety (サブサエティ) EMBROIDERY PARKA BLACK/BLACK
61440 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie White
61441 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie Black
61819 acOlaSia (アコレイジア) VxC hoodie WHITE
61734 NieR (ニーア) DARK GREEN 3POCKET PARKA【DESIGN刺繍】
61671 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) BLACK
61672 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) GRAY
61278 LONELY論理 CHRYSANTHEMUM HOODIE WHITE
61568 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE CREAM
61569 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE BLACK
57408 THRASHER (スラッシャー) TH8501PL MAG LOGO HOODIE BLK/WHT
60813 ROLLING CRADLE COSPLAY GIRL-THUNDER- HOODIE / BLACK
60162 Anti Social Social Club I SEE PINK SPLASH BLACK HOODIE
60161 Anti Social Social Club I SEE BLUE SPLASH BLACK HOODIE
61284 LONELY論理 KAMIKAZE HOODIE BLACK
61285 LONELY論理 KAMIKAZE HOODIE WHITE
60844 エルフリーデ×ゲキクロ×DI:VISIONスペシャル・コラボ・パーカー WHITE
60845 エルフリーデ×ゲキクロ×DI:VISIONスペシャル・コラボ・パーカー GRAY
60846 エルフリーデ×ゲキクロ×DI:VISIONスペシャル・コラボ・パーカーBLACK×RED
60850 エルフリーデ×ゲキクロ×DI:VISIONスペシャル・コラボ・パーカーBLACK×YELLOW
61276 LONELY論理 3EMBROIDERY HOODIE GRAY
61277 LONELY論理 CHRYSANTHEMUM HOODIE BLACK
60841 GoneR Ska Sweat Parka Sand Beige
60842 GoneR Ska Sweat Parka Mix Grey
61153 AFFECTER (アフェクター) LIGHTNING HOODIE BLACK
61155 AFFECTER (アフェクター) AFF TM HOODIE BLACK
61149 AFFECTER (アフェクター) NESS HOODIE BLACK
61150 AFFECTER (アフェクター) NESS HOODIE GREEN
61151 AFFECTER (アフェクター) TAG HOODIE BLACK
60366 GoneR GR30PK002 Circle Rose Parka Sand Beige
60370 GoneR GR30PK002 Circle Rose Parka Black
60339 RUDIE'S (ルーディーズ) PHAT EMBROIDERY HOOD SWEAT WHITE
60878 PSYCHOLOGICAL METAMORPHOSIS BOX LOGO PARKA BEIGE
60814 ROLLING CRADLE COSPLAY GIRL-THUNDER- HOODIE / PINK
60766 ROLLING CRADLE LOGO ROSE HOODIE / RED
60371 GoneR GR30PK001 Chalice Parka Sand Beige
60372 GoneR GR30PK001 Chalice Parka White
60406 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Red
60407 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Orange
60404 GoneR -La Neta- GRL05PK001New York Logo Parka Red
60508 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE NAVY
60507 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE GRAY
60433 ANIMALIA AN21A-SW03 AA FLAG HEAVY Oz HOODIE BLACK
60412 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE BLACK
59014 Subciety (サブサエティ) PIGMENT PARKA - RED
27138 Zephyren (ゼファレン) PARKA -BEYOND- WHITE
27139 Zephyren (ゼファレン) PARKA -BEYOND- BLACK
58414 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA SAX-ORG
58413 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA BLK-RED
59312 Anti Social Social Club A Fire Inside Black Hoodie - Flame
58512 DESURABBITS × ゲキクロ × KAVANE Clothing 限定コラボ・パーカー
58451 Subciety ×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA GRAY
58450 Subciety (サブサエティ)×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA BLACK
57815 四星球×ゲキクロ 限定コラボ・パーカー ブラック
57817 四星球×ゲキクロ 限定コラボ・パーカー ピンク
57818 四星球×ゲキクロ 限定コラボ・パーカー ライトブルー
58328 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO L.BLUE
58327 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO INDIGO
58109 MISHKA M21000404 Pullover WHITE
58110 MISHKA M21000404 Pullover BLACK
57332 Subciety×仮面ライダードライブ MACH PARKA WHITE
58101 WASTED PARIS Hoodie Columbia Bridge Pink
58099 WASTED PARIS Hoodie Columbia Bridge Lilac
58100 WASTED PARIS Hoodie Columbia Bridge Black
58056 NOT COMMON SENSE NCS SNAKE HOODIE WHITE
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
58058 NOT COMMON SENSE NCS FLAME HOODIE BLACK
58003 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT PINK
56458 Subciety (サブサエティ) SOUVENIR PARKA- KHAKI
57412 THRASHER (スラッシャー) TH8501PL MAG LOGO HOODIE NAVY
57414 THRASHER (スラッシャー) TH8528PLGONZ HOODIE WHITE
57397 FILA FS3025 HOODIE NAVY
57351 SUPPLIER (サプライヤー) LOGO HOODIE RED
56451 Subciety (サブサエティ) VANDALIZE PARKA- KHAKI
56919 Half time Old×GEKIROCK CLOTHING 限定コラボ・パーカー
57295 IRON MAIDEN UNISEX PULLOVER HOODIE: LOTB LIVE ALBUM (ARM & BACK PRINT)
56762 RAMONES UNISEX PULLOVER HOODIE: PRESIDENTIAL SEAL
56455 Subciety (サブサエティ) BREAK PARKA- YELLOW
56836 Subcietyx攻殻機動隊 SECTION9 PULLOVER PARKA KHAKI
50552 FOG ESSENTIALS Pullover Hoodie LIGHT HEATHER
56936 SLEEPING TABLET WOOLY [ SUSPEND ANORAK ] BLACK
56896 Anti Social Social Club FOOD COURT BLACK HOODIE
35616 GUNS N' ROSES CLASSIC LOGO PULLOVER
56759 AC/DC UNISEX PULLOVER HOODIE: CANNON SWIG
56202 Anti Social Social Club True Colors Purple Camo
56206 Anti Social Social Club Don’t Red Hoodie
28428 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT BLACK
55130 Zephyren(ゼファレン)PARKA - variat omnia tempus - WHITE
55134 Zephyren(ゼファレン)PARKA - variat omnia tempus - PURPLE
56067 NineMicrophones PARKA-Power of will-BLACK
56026 RUDIE'S (ルーディーズ) PHAT HIGHNECK HOOD SWEAT BLACK
56027 RUDIE'S (ルーディーズ) PHAT HIGHNECK HOOD SWEAT GRAY
54361 Nine Microphones PARKA-Sunforever2020aw- BLACK
55628 Anti Social Social Club SAMSIES BLUE HOODIE
55629 Anti Social Social Club SAMSIES PINK HOODIE
55635 Anti Social Social Club MIND GAMES BLACK HOODIE
11162 MEMPHIS MAY FIRE Crest Black Hooded
11210 THE FACELESS Autotheism Hoodie Black
13803 Subciety TIE DYE ZIP PARKA-EMOTION- GRAY
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal