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 10:08:25')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 60
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
11162 MEMPHIS MAY FIRE Crest Black Hooded
11210 THE FACELESS Autotheism Hoodie Black
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
19014 REVOCATION Deathless Album Black
22786 ANGRY FROG REBIRTH メタルロゴ プルパーカー
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
25135 SEAWAY Colour Blind Logo Grey - Pullover
25484 PIERCE THE VEIL San Diego Navy - Pullover
26230 OPETH Morningrise Hoodie
40491 THRASHER TH8501 MAG LOGO HOODIE NAVY/WHITE
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
52508 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) ORANGE
53927 KEYTALK 丁寧な刺繍パーカー パープル
53928 KEYTALK 丁寧な刺繍パーカー ブラック
28428 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT BLACK
35616 GUNS N' ROSES CLASSIC LOGO PULLOVER
56759 AC/DC UNISEX PULLOVER HOODIE: CANNON SWIG
56762 RAMONES UNISEX PULLOVER HOODIE: PRESIDENTIAL SEAL
56919 Half time Old×GEKIROCK CLOTHING 限定コラボ・パーカー
57397 FILA FS3025 HOODIE NAVY
57412 THRASHER (スラッシャー) TH8501PL MAG LOGO HOODIE NAVY
57414 THRASHER (スラッシャー) TH8528PLGONZ HOODIE WHITE
58003 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT PINK
57818 四星球×ゲキクロ 限定コラボ・パーカー ライトブルー
57817 四星球×ゲキクロ 限定コラボ・パーカー ピンク
57815 四星球×ゲキクロ 限定コラボ・パーカー ブラック
60404 GoneR -La Neta- GRL05PK001New York Logo Parka Red
60407 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Orange
60406 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Red
60372 GoneR GR30PK001 Chalice Parka White
60371 GoneR GR30PK001 Chalice Parka Sand Beige
60339 RUDIE'S (ルーディーズ) PHAT EMBROIDERY HOOD SWEAT WHITE
61149 AFFECTER (アフェクター) NESS HOODIE BLACK
61150 AFFECTER (アフェクター) NESS HOODIE GREEN
61151 AFFECTER (アフェクター) TAG HOODIE BLACK
61153 AFFECTER (アフェクター) LIGHTNING HOODIE BLACK
61155 AFFECTER (アフェクター) AFF TM HOODIE BLACK
60841 GoneR Ska Sweat Parka Sand Beige
60842 GoneR Ska Sweat Parka Mix Grey
57408 THRASHER (スラッシャー) TH8501PL MAG LOGO HOODIE BLK/WHT
61671 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) BLACK
61672 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) GRAY
61734 NieR (ニーア) DARK GREEN 3POCKET PARKA【DESIGN刺繍】
61823 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: LARGE LOGO & ALBUM
62570 Survive Said The Prophet REDEFINE TOUR HOODIE BLACK
62571 Survive Said The Prophet REDEFINE TOUR HOODIE WHITE
62603 HYPER CORE HERE COMES THE PAINフーディー BLACK/BLUE
63328 Meltyglow (メルティグロウ) 総柄半袖PARKA【Fall melty】
63332 Meltyglow (メルティグロウ) 短丈くま耳付きHOODIE
63372 Meltyglow (メルティグロウ) Meltyデザイン刺繍PULLOVER PARKA
64088 Meltyglow (メルティグロウ) Meltyデザイン刺繍PULLOVER PARKA
65549 over print (オーバープリント) over punx Pile Hoodie (white)
65831 NieR (ニーア) FULL GRAPHIC ZIP HOODIE【BLUE】
65823 NieR (ニーア) FULL GRAPHIC ZIP HOODIE
65821 NieR (ニーア) 2WAY OFF-Shoulder 長袖ZIP PULLOVER 【フード刺繍デザイン】
65826 NieR (ニーア) フード刺繍 BLACK PULLOVER PARKA
65858 RUDIE'S (ルーディーズ) BANDGIRL HOOD SWEAT
65552 over print (オーバープリント) over punx Pile Hoodie (red)