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-02 07:12:44')
AND pc.price03 IS NOT NULL
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
63239 DXMOUVE(ドゥモーヴェ) ストレンジトイ切替半袖プルオーバー パープル
42599 Bentham ロゴプルオーバーパーカー
62530 KILL STAR In A State Pull-Over Hoodie
61553 NieR (ニーア) LOGO KNIT HOODIE
61585 Gluttonous Slaughter Obscurity Hoodie
61591 Gluttonous Slaughter Unique Archfiend Hoodie Black
61154 AFFECTER (アフェクター) LIGHTNING HOODIE GREEN
61156 AFFECTER (アフェクター) AFF TM HOODIE NAVY
61641 THRASHER (スラッシャー) TH95166VPL GONZ STROLEING HOODIE BLACK
61642 THRASHER (スラッシャー) TH95166VPL GONZ STROLEING HOODIE L.PINK
61647 THRASHER (スラッシャー) TH95329VPL Collage by M.Sieben HOODIE WHITE
63244 DXMOUVE(ドゥモーヴェ) ぼろぼろベアのtomy切替半袖プルオーバー ピンク
11160 MEMPHIS MAY FIRE Shield Heather Hooded
60651 Subciety (サブサエティ) CLASSIC PARKA GRAY
62529 KILL STAR Bleak Hooded Cape
61596 Gluttonous Slaughter DOOM Hoodie
57411 THRASHER (スラッシャー) TH8501PL MAG LOGO HOODIE GREEN
57415 THRASHER (スラッシャー) TH8528PLGONZ HOODIE GRAY
54521 FILA TOKYO ユニセックス プルオーバーフーディ BLACK
57315 ZERO EVOKE ZE Logo Second Pullover Parka 【BLACK×BLACK】
57316 ZERO EVOKE ZE Logo Second Pullover Parka 【WHITE×WHITE】
61539 ZERO EVOKE Logo Second PARKA WHITE×BLACK
61687 TOY MACHINE (トイマシーン) FLAME FIST SWEAT HOODY NATURAL
61688 TOY MACHINE (トイマシーン) FLAME FIST SWEAT HOODY NAVY
56596 MAGICAL MOSH MISFITS MxMxM HOODIE GRAY
60840 GoneR Ska Sweat Parka Black
60525 MAGICAL MOSH MISFITS MxMxM HOODIE ORANGE
60805 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - BLACK
60807 TOY MACHINE (トイマシーン) TOYDIVISION SWEAT PARKA - BLACK
54430 THRASHER GONZ HOODIE
60745 ガリュウホンポ ビッグロゴプルオーバーパーカー
45657 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: AMO SYMBOLS
57376 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT GRAY
57377 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT PURPLE
57378 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT BLACK
58001 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT BLACK
58002 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT BLUE
60340 RUDIE'S (ルーディーズ) PHAT EMBROIDERY HOOD SWEAT BLACK
60373 GoneR GR30PK001 Chalice Parka Orange
60566 アマツカミ 棘薔薇 Rose Needle Hoodie
60696 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT BLACK
60697 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT RED
60698 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT WHITE
61690 TOY MACHINE (トイマシーン) EYES SWEAT HOODY BLACK
61820 RUDIE'S (ルーディーズ) BRINK PHAT HOOD SWEAT BLACK
62164 RUDIE'S (ルーディーズ) HELLO HOOD SWEAT BLACK
62166 RUDIE'S (ルーディーズ) COLLEGE HOOD SWEAT BLACK
62169 KILL STAR Damned Hoodie
62902 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. SWAET PARKA - BEIGE
64331 NieR (ニーア) HALF ZIP HOODIE【broken heart】
60367 GoneR GR30PK002 Circle Rose Parka White
60753 HYPER CORE O-182 VACCINATEDフーディー 白
53915 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLUE
60681 DI:VISION ENVIOUS HOODIE BLACK
59393 MAGICAL MOSH MISFITS MxMxM パイル PARKA TEE PURPLE
60928 PUNK DRUNKERS [PDSx太鼓の達人]パーカーだドン!パーカー - BLACK
60632 TRAVAS TOKYO【トラバストーキョー】Furry bear Hoodie Gray
60707 SABBAT13 WIND PRANK HOODIE BLACK
60708 SABBAT13 WIND PRANK HOODIE BLUE
57100 Survive Said The Prophet SIDE ZIP HOODIE
60683 DI:VISION THORN HOODIE BLACK
61152 AFFECTER (アフェクター) TAG HOODIE GRAY
63693 NieR (ニーア) HALF ZIP HOODIE
61643 THRASHER (スラッシャー) TH95166VPL GONZ STROLEING HOODIE ORANGE
61646 THRASHER (スラッシャー) TH95329VPL Collage by M.Sieben HOODIE BLACK
57182 acOlaSia poison hoodie BLACK
61818 acOlaSia (アコレイジア) VxC hoodie BLACK
60464 NieR (ニーア) BIG POCKET MARINE PARKA
61079 VIRGO VGW BUDDY HOODIE BLACK
61227 TRAVAS TOKYO【トラバストーキョー】サッドネスバニープルオーバーパーカー White
61727 TRAVAS TOKYO【トラバストーキョー】切り替え総柄バイカラーパーカー マルチカラー
56307 NineMicrophones PARKA-Pain of My life BLACK
56877 MISHKA(ミシカ) MAW200470 HOODIE ORANGE
59647 Zephyren(ゼファレン) PARKA - Elysium - BLACK
63180 THRASHER (スラッシャー) Godzilla Flame Hood Black
63181 THRASHER (スラッシャー) Mexico Revista Hood Black
56788 TRAVAS TOKYO【トラバストーキョー】Rhinestone Crown bear Hoodie White
60409 TRAVAS TOKYO【トラバストーキョー】リフレクターベアプルオーバーパーカー White
56068 NineMicrophones PARKA-Power of will-GRAY
56449 Subciety (サブサエティ) VANDALIZE PARKA- BLACK
56454 Subciety (サブサエティ) BREAK PARKA- BLACK
57413 THRASHER (スラッシャー) TH8528PLGONZ HOODIE BLACK
59037 Subciety (サブサエティ) Separation PARKA - BLACK
59038 Subciety (サブサエティ) Separation PARKA - GRAY
61408 THRASHER (スラッシャー) TH85226PL ICE LOGO HOODIE WHITE
61409 THRASHER (スラッシャー) TH95231PL RED MAG LOGO HOODIE BLACK
61759 MISHKA (ミシカ) M21100407 HOODIE
61543 ZERO EVOKE Logo Second PARKA RED
54223 ANIMALIA S/S SIDE ZIP HOODIE NAVY
63065 ANIMALIA AN22SP-SW07 DOUBLE KNIT HOODIE-Overlap Logo KHAKI
56110 N.B.O. FLOWER PATCH SWEATER KHAKI
60589 RIPNDIP Stellar Hoodie (Purple/Blue Spiral Dye)
60595 RIPNDIP Peeking Nermal Embroidered Hoodie (Purple Mineral Wash)
58102 WASTED PARIS Hoodie Faithless Black
59903 PUNK DRUNKERS [PDSxSONIC]ソニックパーカ - BLACK
60167 MISHKA X DENNIS THE MENACE TROUBLE MAKER HOODIE RED
61508 Subciety (サブサエティ) PARKA-PROVIDENCE- BLACK/WHITE
61839 Subciety (サブサエティ) EMBROIDERY PARKA GRAY
43342 BRING ME THE HORIZON DYNAMITE HOODIE
56598 MAGICAL MOSH MISFITS MxMxM どろどろドクロ HOODIE GRAY
60526 MAGICAL MOSH MISFITS MxMxM HOODIE RED
60806 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - M. GREY
55016 Zephyren(ゼファレン)LINE PARKA - Resolve - NAVY
56021 Subciety (サブサエティ) HALF ZIP BOA PARKA CAMEL
57333 Subciety×仮面ライダードライブ MACH PARKA BLACK
59010 Subciety (サブサエティ) Robin PARKA - BLUE
59011 Subciety (サブサエティ) Robin PARKA - PURPLE
59013 Subciety (サブサエティ) PIGMENT PARKA - BLUE
59515 Zephyren(ゼファレン) DOLMAN BIG PARKA BLACK / Creux
59523 Zephyren(ゼファレン) DOLMAN BIG PARKA RED / Reverie
59540 Zephyren(ゼファレン) LINE PARKA - VISIONARY - BLACK
60374 GoneR GR30PK001 Chalice Parka Hether Grey
60499 Subciety (サブサエティ) Layered PARKA BEIGE
60500 Subciety (サブサエティ) Layered PARKA ORANGE
60503 Subciety (サブサエティ) SEA OTTER PARKA BURGUNDY
60504 Subciety (サブサエティ) SEA OTTER PARKA BLACK
60726 MISHKA M61000452 HOODIE
62163 RUDIE'S (ルーディーズ) HELLO HOOD SWEAT LIGHT BLUE
63556 glamb (グラム) Bizarre Cord Hoodie - White
65778 アマツカミ 悲嘆/grief Hoodie