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 dtb_products AS p
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 10:49:41')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
40042 Zephyren BIG SHIRT S/S -Resolve- GEO WHITE
65338 Subciety (サブサエティ) STONE NECKLACE
14355 FAMOUS STARS AND STRAPS DESTROYER Mens Snap Fleece
20698 Subciety SWEAT-CAMOUFLAGE SALOON- WHITE
20704 Subciety (サブサエティ) SWEAT-COLLEGE- BLACK/ORANGE
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL
35482 Zephyren (ゼファレン) SWEAT -PORTAL- BLACK
35835 Zephyren (ゼファレン) BIG JAGUARD KNIT -Cut the world- BLACK
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress
37055 MARILYN MANSON×KILL STAR CLOTHING Deformography Belt [S]
51291 ROLLING CRADLE FLEECE JACKET / Black
51510 MISHKA MSS200055F12 L/S TEE SAFTY GREEN
60666 MISHKA M61000729 JACKET GRAY
54642 THRASHER TH8177A S.A.D Tee WHITE
54643 THRASHER TH8177A S.A.D Tee BLACK
41612 RIPNDIP Nermal 3M Line Camo Anorak Jacket (Black)
45758 RIPNDIP Multi Knit Sweater (Multi)
16679 【ゲキクロ限定カラー】lynch. ツアーTシャツ BLUE
16682 【ゲキクロ限定カラー】lynch. ツアーTシャツ GRAY
7047 RUDIE'S (ルーディーズ) AGAINST-Tee BLACK/WHITE
8059 KILL STAR CLOTHING METAL T-SHIRT [B]
9419 WE CAME AS ROMANS Truth Black T-Shirt
9874 KILL STAR CLOTHING ABRACADABRA TANK [B]
10021 Subciety Kurt Cobain × Subciety S/S -Dive-BLK
10828 MISHKA (ミシカ) GHOST TO THE POST II TANK TOP BLACK
11084 MISHKA (ミシカ) PARTY ANIMAL T-SHIRT RED
11189 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-DENI
11582 KILL STAR CLOTHING LUCIFER TANK [B]
12661 KILL STAR CLOTHING WISH DRESS [B]
12976 HOLYSHITz Hexagram T-shirts sumi
14181 METALLICA RIDE LYRICS All Over TEE
17711 RIP DESIGN WORXX ripdwスタンダードロゴTシャツ BLACK
17819 NineMicrophones King Of The Road S/S CHARCOAL
18308 PUNK DRUNKERS CITY. TEE WHITE
20823 Subciety DENIM TYPE 81 BLACK
22892 Zephyren (ゼファレン) THRASHER x Zephyren S/S TEE -PENETRATE- BLACK
23083 Subciety(サブサエティ) GLORIOUS S/S-MELT- WHITE/BLUE
23330 GoneR Logo T-Shirts Ver.3 - Grey
27484 MISHKA (ミシカ) JV KEEP WATCH BASKETBALL JERSEY White
29535 CARCASS UNFIT TEE
29707 SABBAT13 MONSTERS C/N SWEAT GREY
31689 Subciety PAISLEY POCKET STRIPE SHIRTS L/S-Conductor- NAVY
32181 DOCAN! SUPERNORMAL CLUB Jacket OD
34389 PUNK DRUNKERS 【PDSxTREST】TPU iPhone case(STAR PKDS)
34390 PUNK DRUNKERS 【PDSxTREST】TPU iPhone case(花の妖精)
34962 SABBAT13 S-BONE ZIP HOODIE (グレー) GRAY
35286 SLIPKNOT Long Sleeved Tee: Blocks
35392 Zephyren (ゼファレン) BIG S/S TEE -ENGRAVE- BLACKxWHITE
38443 Zephyren (ゼファレン) BANDANA SHORTS CAMO
38833 MISHKA (ミシカ) LAMOUR SCUM LOVE T-SHIRT FL 171116 YEL
39172 KORN Face in the Fire Tanktop
39515 SABBAT13 HAND OF GLORY ZIP HOODIE (NAVY)
40180 Zephyren BANDANA SHORTS BLACK
40647 MISHKA SP181303 FLYING TIGER KEEP WATCH TEE BLACK
41254 RIP DESIGN WORXX グレイヴメイカーパンダTシャツ GRAY
41630 RIP DESIGN WORXX カフェタンブラー AUTOGRAPH WHITE
41902 ROLLING CRADLE RC VULGAR PANTS Blue
42873 MISHKA x AIR JAM 2018 TEE WHITE
45484 TOY MACHINE TMS19ST17 SECT PROTOP PRINT SS TEE BLACK
46150 Subciety (サブサエティ) WORK SHIRT-Primal- WHITE
46151 Subciety (サブサエティ) WORK SHIRT-Primal- BLACK
46341 Zephyren(ゼファレン)S/S TEE - alea iacta est / milestone - BLACK
46345 Zephyren(ゼファレン)S/S TEE - MONOLITH - WHITE
46450 Zephyren(ゼファレン)BIG TANKTOP BLACK / 如意宝珠
47524 VIRGO VG-CUT-381 VINTAGE RAGLAN CUTSEW 染めカットソー BLACK
47733 MAGICAL MOSH MISFITS MxMxM 8 POCKETS SHORTS 000 “POCKET SLIME MISFITS” BEIGE
48555 MAGICAL MOSH MISFITS MxMxM 水陸両用 どろどろパンツ BLACK
48688 Zephyren(ゼファレン) LONG SHIRT L/S BLACK / 如意宝珠
48786 Zephyren(ゼファレン) L/S TEE - apocalypse - WHITE
49813 Subciety (サブサエティ) elements S/S WHITE
49919 Subciety (サブサエティ) TAG S/S WHITE/GREEN
49941 DI:VISION “EPHEMERAL” L/S TEE BLACK
51193 SLIPKNOT UNISEX FASHION TEE: LOGO & STAR (APPLIQUE MOTIFS)
51390 KAVANE Clothing "criticize"Long Sleeve(Red)
52001 Zephyren(ゼファレン) S/S TEE -BEYOND- D.GREEN/WHITE
52024 Zephyren(ゼファレン) S/S TEE -Got lst Todi- WHITE
52750 Subciety EMBLEM SHIRT -TRIBALCAMO- BLACK
53924 THRASHER THRASHER DAVID GONZALEZ T-SHIRTS BLUE
54330 Subciety (サブサエティ) SKINNY PANTS BLACK
54381 Nine Microphones -walkin'mic- S/S - WHITE
54644 THRASHER TH91257 JAN 82 S/S T-SHIRTS
55658 MISHKA (ミシカ) KEEP WATCH SWIM SHORTS
56547 Nine Microphones PRINTED POLO-9MC Crew-BKBRG
56550 Nine Microphones STUDS SHIRT S/S -Comrade- DENIM
56553 NineMicrophones 9MC Crew S/S White/Burgundy
56555 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-BGN
56556 Nine Microphones BORDER TEE L/S -9MC Vrew- WHITE
56557 Nine Microphones RAISED SHIRT S/S -The angel GREEN
56559 Nine Microphones WORK SHIRT S/S -Power of will- MU
56560 HOLDTUBE 15:KINGDOM NAVY ROLL HOLDER
56568 THRASHER mini towel RED
56569 SO SO HAPPY BEANIE WHITE
56570 ICECREAM IC13H255 Beanie RED
56571 DISTURBIA CLOTHING Slacker Beanie
56572 NineMicrophones 9MC Crew S/S Blue
56573 SO SO HAPPY Be My Monster Puff Girls T-Shirt
56574 SO SO HAPPY Lucky Wink In Grey
56575 ICECREAM MASH S/S T-SHIRT BLACK
56576 ICECREAM L/S GHOST KNIT JAKET BLACK
56843 FAMOUS STARS AND STRAPS Fam Grown FF GRAY
37117 SILLENT FROM ME RUBRIC -Crew Sweat- BLACK
51154 SLEEPING TABLET×火寺バジル(魔法少女になり隊)コラボ・Tシャツ BLACK
51155 SLEEPING TABLET×火寺バジル(魔法少女になり隊)コラボ・Tシャツ WHITE
50355 GALFY 色最高パーカー NAVY
52052 Zephyren(ゼファレン) SAROUEL SWEAT PANTS BLACK
51493 NieR (ニーア) ポケット付総柄ペイント半袖パーカー
8926 THRASHER (スラッシャー) TH8501 MAG LOGO HOODIE BK/GRY
10639 THRASHER TH8501 MAG LOGO HOODIE BRG/WHT
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
23340 GoneR Logo Ver.2 Tank-Top - White
51479 KONUS K-80616 Mock Collar Bomber Jacket with Pockets BLACK
45543 Zephyren(ゼファレン)SWEAT -MONOLITH- YELLOW
6616 MISHKA The Keep Watch or Die Tank in Navy
9306 MISHKA (ミシカ) KEEP WATCH CARDIGAN RED BERRY
52438 SABBAT13 PARADISE HOODIE(ブラック)
52439 STAPLE Supernova Bubble Jacket
52447 STAPLE Neo Sport Nylon Crew
52461 GALFY (ガルフィー) 野良犬カバーオール 青野良犬
52462 GALFY (ガルフィー) 犬パーカー 黒
45387 GALFY 色絶妙パーカー NAVY