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 =393
)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-25 22:21:23')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 840, 120
28307 SET IT OFF Duality Black - Zip-Up Sweatshirt
28431 RUDIE'S DRAWING ZIPHOOD SWEAT BLK
28432 RUDIE'S DRAWING ZIPHOOD SWEAT GRY
28433 RUDIE'S DRAWING ZIPHOOD SWEAT NVY
28547 Gluttonous Slaughter (グラトナス・スローター) lnversion of Christ ZIP HOODIE BLACK
28548 Gluttonous Slaughter (グラトナス・スローター) lnversion of Christ ZIP HOODIE BLUE
28757 BLACK SCALE RESISTANCE ZIP HOODIE BLACK
28758 BLACK SCALE BLVCK REBELS ZIP HOODIE BLACK
28759 BLACK SCALE BLVCK REBELS ZIP HOODIE GREY
28763 VIRGO CARPE DIEM ZIP PARKA BLACK
28765 VIRGO SWITCHING SPORTS HOOD BK-GYhood
28766 VIRGO SWITCHING SPORTS HOOD GRY-BLK
28767 VIRGO SWITCHING SPORTS HOOD WHT-BLK
28802 SILLENT FROM ME DROUGHT -Ziphood- BLACK
28803 SILLENT FROM ME DROUGHT -Ziphood- WHITE
28819 RIP DESIGN WORXX ロゴジップアップパーカーホワイト
28820 RIP DESIGN WORXX ロゴジップアップパーカーグレー
28840 FAR★STAR OCTOPUS Eddy ジップパーカー
28843 FAR★STAR クリオネパーカー
28965 PUNK DRUNKERS スワットパーカ GRAY
28966 PUNK DRUNKERS スワットパーカ BLACK
29013 SQUARE GENOCIDE HOODY WHITE
29014 SQUARE GENOCIDE HOODY BLACK
29015 SQUARE ARM PRINT ZIPUP LIGHT HOODY GRAY
29016 SQUARE ARM PRINT ZIPUP LIGHT HOODY BLACK
29103 PARADOX - GRAPHIC WIDE ZIP PARKA (MAGIC)
29104 PARADOX - GRAPHIC WIDE ZIP PARKA (BANDANNA)
29105 PARADOX - WIDE ZIP PARKA (BLACK)
29119 THRASHER TH96177 BLK/WHT
29120 THRASHER TH96177 BLK/RED
29121 THRASHER TH9605 NECKFACE ZIP HOODIE WHT
29122 THRASHER TH9605 NECKFACE ZIP HOODIE BLU
29123 THRASHER TH9605 NECKFACE ZIP HOODIE BUR
29131 RUDIE'S SPARK ZIPHOOD SWEAT BLACK/BLACK
29223 Subciety (サブサエティ) PARKA S/S-GLORIOUS- RED
29593 VIRGO FRAGMENT MONSTER PARKA BLACK
29594 VIRGO FRAGMENT MONSTER PARKA GRAY
29646 GoneR Basic Logo Zip Parka White
29649 GoneR Basic Logo Zip Parka Black
29687 Hypocrite (ヒポクリット) THE LEADER FULLJIP HOODY
29695 SABBAT13 GLOOMY HUMMING ZIP-PARKA BLACK
29696 SABBAT13 GLOOMY HUMMING ZIP-PARKA GREY
29697 SABBAT13 MORTAL ZIP-PARKA BLACK
29698 SABBAT13 MORTAL ZIP-PARKA GREY
29699 SABBAT13 CHILLER P/O PARKA BLACK
29712 SABBAT13 MESSAGE from IGOR L/L ZIP-PARKA
29726 THRASHER THKH-ZHD10 ZIP HOODIE BLACK
29727 THRASHER THKH-ZHD10 ZIP HOODIE WHITE
29728 THRASHER THKH-ZHD10 ZIP HOODIE GRAY
29752 SABBAT13 HAND MONSTER "VAMP" ZIP-PARKA (BK)
29753 SABBAT13 HAND MONSTER "VAMP" ZIP-PARKA (GY)
29754 SABBAT13 HAND MONSTER "FRANK" ZIP-PARKA (BK)
29755 SABBAT13 HAND MONSTER "FRANK" ZIP-PARKA (GY)
29756 SABBAT13 RESURGENT ZIP-PARKA (RD)
29836 SQUARE (スクエア) ZIPUP LOGO HOODY BLACK
29885 REBEL8 DESCANSO ETERNO ZIP-UP BLACK HOODIE
29921 REBEL8 HEART AND SOUL ZIP UP HOODIE BLACK
29948 SABBAT13 MESSAGE from IGOR L/L ZIP-PARKA GRAY
29968 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) BLACK MASS MENS ZIP HOODY
29969 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) BOXED IN MENS ZIP HOODY
29970 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) VICIOUS MENS ZIP HOODY
30002 MISHKA (ミシカ) LAMOUR SUPREME: SPLIT ICONS ZIP UP HOODIE BLACK
30111 MISHKA (ミシカ) BACK OFF! ZIP UP HOODIE BLACK
30153 Zephyren(ゼファレン) ZIP PARKA -CocaCola- WHITE
30154 Zephyren(ゼファレン) ZIP PARKA -CocaCola- BLACK
30243 Zephyren(ゼファレン) ZIP PARKA -X-RAY SKULL- BIGSKULL
30255 Zephyren(ゼファレン) LIGHT WEIGHT ZIP PARKA -SPADE- BLACK
30262 Zephyren(ゼファレン) LIGHT WEIGHT ZIP PARKA -ENGRAVE- BLACKxWHITE
30265 Zephyren(ゼファレン) LIGHT WEIGHT ZIP PARKA -ENGRAVE- GRAY
30269 Zephyren(ゼファレン) LIGHT WEIGHT ZIP PARKA -SPADE FLAME- BLACKxWHITE
30413 Zephyren(ゼファレン) STUDS ZIP PARKA BLACKxSILVER
30415 Zephyren(ゼファレン) STUDS ZIP PARKA GRAYxSILVER
31660 SQUARE (スクエア) CAMO SWEAT HOODY BLUE
31661 SQUARE (スクエア) CAMO SWEAT HOODY GRN
31719 DISTURBIA CLOTHING Situationist Hoody
31734 Xmas Eileen ONLY THE BEGINNING ジップアップパーカー(紺)
31735 Xmas Eileen ONLY THE BEGINNING ジップアップパーカー(赤)
31736 Xmas Eileen ONLY THE BEGINNING ジップアップパーカー(迷彩)
31772 MARILYN MANSON×KILL STAR CLOTHING (キルスター・クロージング) Death In 1996 Zip Hoodie [B]
31832 MISHKA (ミシカ) MFA150523M99 ZIP HOODIE
31877 LILWHITE(dot) (リルホワイトドット) -ICONIC- FRONT ZIP HOODIE BLACK
31880 LILWHITE(dot) (リルホワイトドット) -ICONIC- FRONT ZIP HOODIE WHITE
31881 LILWHITE(dot) (リルホワイトドット) -ICONIC- FRONT ZIP HOODIE GRAY
31908 RideMe RM Small Logo ZipHoodie TigerCamo
31909 RideMe s.t.e Logo ZipHoodie BLK
31960 DEADHEARTZ HELL ZIP HOODIE BLACK
31961 DEADHEARTZ HELL ZIP HOODIE GRAY
31997 FAR★STAR 夏の終わり パーカー
32071 PUNK DRUNKERS 目ん玉ウルフパーカ BLACK
32072 PUNK DRUNKERS 目ん玉ウルフパーカ GRAY
32092 【限定デザイン】 BAND-MAID x deathsight ZIP UP HOODIE
32110 THE TEST ZIP PARKA INNERSPACE'16 (GRAY)
32111 THE TEST ZIP PARKA INNERSPACE'16 (BLACK)
32197 Gluttonous Slaughter (グラトナス・スローター) I Need You Dead Zip-UP HOODIE WHITE
32198 Gluttonous Slaughter (グラトナス・スローター) I Need You Dead Zip-UP HOODIE BLACK
32320 REBEL8 HELL CAN'T US ZIP-UP HOODIE
32327 SILLENT FROM ME ENCRYPTION -Ziphood- BLK
32328 SILLENT FROM ME ENCRYPTION -Ziphood- WHT
32358 REBEL8 SKATE CORE ZIP-UP HOODIE
32359 REBEL8 TOAST TO THE WORST ZIP-UP HOODIE
32409 KILL STAR CLOTHING Rage Riot Fire Starter Hoodie [B]
32415 PARADOX - GRAPHIC BIG PARKA (EXPLOSION)
32416 PARADOX - GRAPHIC BIG PARKA (NEO-MAGIC)
32556 VIRGO Fortress Big Hood Parka BLACK
32557 VIRGO Fortress Big Hood Parka GRAY
32582 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) SOCIALLY DISTORTED Zip
32812 Bentham サークルロゴパーカー ブラック
33038 SPITFIRE CIRCLE ZIP HOODIE GUNMETAL HEATHER
33040 SPITFIRE CSWIRL HOODIE WHITE
33075 ALL OFF×LILWHITE(dot) SEEKER ZIP HOODIE
33497 REBEL8 ANIMOSITY ZIP-UP HOODIE
33612 MISHKA (ミシカ) Death Adder Zip Up Army Heather
33613 MISHKA (ミシカ) Death Adder Zip Up Black
33792 ANIMALIA AN17U-SW02 ANCHOR Sweat-Slashed BLACK
33908 BAND-MAID KAgaMI Design ZIP UP HOODIE
33933 KILL STAR CLOTHING (キルスター・クロージング) In Like Sin Zip Hoodie [B]
34082 Zephyren(ゼファレン) ZIP PARKA -glossy girl- WHITE
34084 Zephyren(ゼファレン) ZIP PARKA -glossy girl- BLACK
34085 Zephyren(ゼファレン) ZIP PARKA -melt hand- WHITE
34086 Zephyren(ゼファレン) ZIP PARKA -melt hand- BLACK×WHITE