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-04-28 09:31:23')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 3120, 120
52592 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO & STAR (APPLIQUE MOTIFS)
52596 TOY MACHINE TMP20SW15 PULLOVER PARKA BLACK
52598 TOY MACHINE TMP20SW15 PULLOVER PARKA ASH GRAY
52601 PUNK DRUNKERS 手足がフォントパーカ GRAY
52602 PUNK DRUNKERS 手足がフォントパーカ PURPLE
52650 TRAVAS TOKYO Edgy rabbit Hoodie BLACK
52651 TRAVAS TOKYO Edgy rabbit Hoodie BLACK/PURPLE
52652 TRAVAS TOKYO Edgy rabbit Hoodie WHITE
52655 TRAVAS TOKYO Butler bear Hoodie BLACK
52656 TRAVAS TOKYO Butler bear Hoodie WHITE
52666 REBEL8×SLAYER Slayer Army Pullover Hoodie
52667 REBEL8×SLAYER South Of Heaven Pullover Hoodie
52685 MISHKA Crack the Crust Hoodie Black
52686 MISHKA Crack the Crust Hoodie Gold
52689 MISHKA Samurai Keep Watch Hoodie Black
52690 MISHKA Mono Stack Hoodie Hoodie Black
52694 MISHKA x Grape Brain "Keep Watch Onigiri" Hoodie
52705 RIPNDIP Nermio Hoodie (Tan)
52706 RIPNDIP Rock N Nerm Hoodie (Black)
52707 RIPNDIP Catch Em All Hoodie (Multi)
52725 CIVARIZE【シヴァーライズ】Vice ドレープフードスカル総柄ポンチョ
52890 ANIMALIA AN20SP-SW02 150 Country Jail-P/O Hoodie BLACK
52891 ANIMALIA AN20SP-SW02 150 Country Jail-P/O Hoodie WHITE
52892 ANIMALIA AN20SP-SW02 150 Country Jail-P/O Hoodie ORANGE
52914 FILA × STAPLE FM9880 BLACK
52915 FILA × STAPLE FM9880 WHITE
52924 LILWHITE(dot) LW-20SS-SW02 "LOSER" DAMAGED HOODIE (BLK)
52925 LILWHITE(dot) LW-20SS-SW02 "LOSER" DAMAGED HOODIE (PPL)
52926 LILWHITE(dot) LW-20SS-SW02 "LOSER" DAMAGED HOODIE (GRN)
52927 LILWHITE(dot) LW-20SS-SW04 "DIM" HOODIE
52936 RUDIE'S DRAWING HOOD SWEAT YELLOW
52937 RUDIE'S DRAWING HOOD SWEAT WHITE
52938 RUDIE'S DRAWING HOOD SWEAT BLACK
52957 RIPNDIP Catch Em All Hoodie (Tan)
52974 acOlaSia PHENOMENON HOODIE BLACK
52975 acOlaSia PHENOMENON HOODIE YELLOW
53014 DI:VISION SUBSCRIBE HOODIE
53071 ガリュウホンポ 子袖切プルオーバーパーカー
53074 SAMURAI CORE 釈迦 HOODIE BLACK
53075 SAMURAI CORE 釈迦 HOODIE WHITE
53076 SAMURAI CORE 釈迦 HOODIE RED
53110 SAMURAI CORE 夜露死苦哀愁 HOODIE BLACK
53111 SAMURAI CORE 夜露死苦哀愁 HOODIE WHITE
53112 SAMURAI CORE 夜露死苦哀愁 HOODIE RED
53127 RIP DESIGN WORXX クマドリパーカー PURPLE
53128 RIP DESIGN WORXX クマドリパーカー YELLOW
53135 RIP DESIGN WORXX クマドリパーカー BLACK
53198 MISHKA (ミシカ) MSS200104F99 HOODIE BLACK
53199 MISHKA (ミシカ) MSS200104F80 HOODIE WHITE
53200 MISHKA(ミシカ) MSS200411W99 HOODIE BLACK
53201 MISHKA(ミシカ) MSS200411W12 HOODIE SAFTY GREEN
53883 MISHKA(ミシカ) MSS200072 HOODIE BLACK
53889 PARADOX PX17-SP-PK01 HALF ZIP PARKA 「Never tear us apart」 BLACK
53890 PARADOX PX17-SP-PK01 HALF ZIP PARKA 「Never tear us apart」 VIOLE
53891 PARADOX PX17-SP-PK01 HALF ZIP PARKA 「Never tear us apart」 WHITE
53892 PARADOX PX17-SP-PK02 INSIDE OUT PARKA「FACE TO FACE」 BLACK
53893 PARADOX PX17-SP-PK02 INSIDE OUT PARKA「FACE TO FACE」 VIOLET
53894 PARADOX PX17-SP-PK02 INSIDE OUT PARKA「FACE TO FACE」 GRAY
53914 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA WHITE
53915 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLUE
53916 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLACK
53917 PSYCHOLOGICAL METAMORPHOSIS PLMP PILE WAPPEN PARKA GREEN
53918 PSYCHOLOGICAL METAMORPHOSIS PLMP WALL PARKA RED
53919 PSYCHOLOGICAL METAMORPHOSIS PLMP WALL PARKA BLACK
53927 KEYTALK 丁寧な刺繍パーカー パープル
53928 KEYTALK 丁寧な刺繍パーカー ブラック
53937 そこに鳴る ビッグシルエットパーカー
53941 Bentham big silhouette hoodie
53947 NOT COMMON SENSE ”NCS FILM” HOODIE
53966 SILLENT FROM ME 沈黙 -Pullover- BLACK
54110 FILA ユニセックス プルオーバーフーディ
54134 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] SAX
54135 SILLENT FROM ME SHHH -Long Length Parka- BLACK
54136 SILLENT FROM ME SHHH -Long Length Parka- WHITE
54221 ANIMALIA S/S SIDE ZIP HOODIE GRAY
54222 ANIMALIA S/S SIDE ZIP HOODIE RED
54223 ANIMALIA S/S SIDE ZIP HOODIE NAVY
54430 THRASHER GONZ HOODIE
54519 FILA TOKYO ユニセックス プルオーバーフーディ WHITE
54520 FILA TOKYO ユニセックス プルオーバーフーディ RED
54521 FILA TOKYO ユニセックス プルオーバーフーディ BLACK
54650 CIVARIZE【シヴァーライズ】 レースアップZIPプルオーバーパーカー WHITE
54651 CIVARIZE【シヴァーライズ】 レースアップZIPプルオーバーパーカー BLACK
54709 MISHKA (ミシカ) KUMARA HOODIE
54710 MISHKA (ミシカ) BUTIGER HOODIE
53884 MISHKA(ミシカ) MSS200072 HOODIE WHITE
52995 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO (BACK PRINT)
50604 GALFY (ガルフィー) 野良犬ダブダブパーカー 青野良犬
45387 GALFY 色絶妙パーカー NAVY
52462 GALFY (ガルフィー) 犬パーカー 黒
52438 SABBAT13 PARADISE HOODIE(ブラック)
8926 THRASHER (スラッシャー) TH8501 MAG LOGO HOODIE BK/GRY
10639 THRASHER TH8501 MAG LOGO HOODIE BRG/WHT
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
51493 NieR (ニーア) ポケット付総柄ペイント半袖パーカー
50355 GALFY 色最高パーカー NAVY