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-25 07:32:08')
AND pc.stock > 0
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 10
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress
11582 KILL STAR CLOTHING LUCIFER TANK [B]
46450 Zephyren(ゼファレン)BIG TANKTOP BLACK / 如意宝珠
56555 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-BGN
56570 ICECREAM IC13H255 Beanie RED
56572 NineMicrophones 9MC Crew S/S Blue
56573 SO SO HAPPY Be My Monster Puff Girls T-Shirt
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
52439 STAPLE Supernova Bubble Jacket
52447 STAPLE Neo Sport Nylon Crew
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
53239 【予約商品】Zephyren(ゼファレン)SWITCHING SHIRT S/S WHITE / RED
7258 Artemis Classic ダークドラゴンペンダント[ACP0249]
7269 Artemis Classic トレサリースリーピースレザーブレス[ACB0064]
7519 Artemis Classic ルシフェルウイングリングPAVE[ACSR0006PAVE]
7526 Artemis Classic トレサリーブラックスピネルネックレス[ACCN0008]
7532 Artemis Classic スタイリッシュクロスウォレットチェーン[ACWC0010]
9643 ICECREAM RACING DOG S/S T-SHIRT PURPLE
9644 SLIP&Co. BAMBINX TEE BLACK
9891 KILL STAR CLOTHING GRUMPY SWEATSHIRT
11229 Nine Microphones HEAVEN S/S Gray
11285 Nine Microphones BE ON STAGE S/S BLACK
11287 Nine Microphones BE ON STAGE S/S DENIM
11735 SLIP&Co. 13 FOOTBALL TOP Green/Yellow
12162 SPITFIRE MASSACRE S/S Tee BLACK
13399 ICECREAM FAST DOG TEE SU14 GRAY
13803 Subciety TIE DYE ZIP PARKA-EMOTION- GRAY
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
14880 SO SO HAPPY You Make Me Melt
14988 Agape Attire SON OF THE MOST HIGH TEE
15159 フクザワ 部屋 クリアファイル
15171 フクザワ 知らん女の自撮りTシャツ
15177 フクザワ 白綿缶バッジ
15178 フクザワ 冷戦 缶バッジ
15179 フクザワ 無限くん 缶バッジ
15886 フクザワ 飼われ男 Tシャツ
16037 Subciety PAISLEY TEE-Parantica sita- BLACK
16568 REBEL8 WOMENS HI-RISE INDIGO JEAN
16590 KILL STAR CLOTHING KABBALAH HOOD DRESS [B]
16592 KILL STAR CLOTHING MOONCHILD SKATER DRESS [B]
16714 ICECREAM CONES&BONES T-SHIRT T04 WHITE
16983 ZEPHYREN (ゼファレン) TANK TOP -BONEYARD- - BLACK
17603 ICECREAM BALLERS T-SHIRT ROYAL
17655 ICECREAM RUNNING DOG GLOW IN THE DARK WHITE
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
18360 Subciety EMBLEM SHIRT L/S - BLACK.STAR
18831 KILL STAR CLOTHING PIZZA ORDER MUSCLE TANK [B]
19063 HOLDTUBE HT-0403 TOUCH FUSION UNIVERSE
19088 SABBAT13 BONE LADY 13X iPhone SKIN+JKT 6plus WHITE
19089 SABBAT13 BONE LADY 13X iPhone SKIN+JKT 6+ BLACK
19091 SABBAT13 BONE CAMO iPhone SKIN+JKT 6+ GREEN
19179 アマツカミ MICE クリアファイル
19716 ZEPHYREN (ゼファレン) METAL RING -VISIONARY - GOLD
19919 LIVEHOLIC GRAND OPENING SERIES Limited T-Shirt WHT
20065 ICECREAM VARSITY GREY
20067 ICECREAM ICEFA HEATHER GREY
20100 KILL STAR CLOTHING PENTAGRAM EARRINGS[P]
20113 KILL STAR CLOTHING KALI DENIM VEST [B]
20115 KILL STAR CLOTHING RA T-SHIRT [B]
20119 KILL STAR CLOTHING OM TUNIC DRESS [B]
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
20124 KILL STAR CLOTHING SPIRITUS L/S MAXI DRESS [B]
20169 FUZZ REZ ZWEEP DELAY TEE BLK
20170 FUZZ REZ ZWEEP DELAY TEE WHT
20303 REBEL8 GR8FUL TEE
20337 AGAPE ATTIRE Militello Script Ringer Tee
20339 AGAPE ATTIRE CLASSIC SCRIPT TANK
20483 FAR★STAR 百目♀鼠 T&ショートT
20485 FAR★STAR Sperm ショートT フリーサイズ
20654 Subciety EMBLEM VEST STRIPE
20716 Subciety PARKA-CAMOUFLAGE SALOON- BLACK
20722 Subciety (サブサエティ) PARKA-COLLEGE- GRAY/BURGUNDY
20751 Subciety BASEBALL TEE 7/S-COLLEGE- GRAY
21079 ライブキッズあるある ライブキッズTシャツ
21080 フクザワ JKコンビニシール
21083 フクザワ あの日のこと Tシャツ
21159 BLACK CRAFT Aquarius
21732 ROLLING CRADLE WAVELET SHIRT / White
22095 FUZZ REZ ZWEEP DELAY LONG SLEEVE TEE BLK
22098 FUZZ REZ ZWEEP MODULATION TEE BLK
22099 FUZZ REZ ZWEEP MODULATION TEE GRY
22102 FUZZ REZ ZWEEP BIT CRUSHER TEE BLK
22103 FUZZ REZ ZWEEP BIT CRUSHER TEE WHT
22188 KILL STAR CLOTHING(キルスター・クロージング) Azrael T-Shirt
22262 KILL STAR CLOTHING Azrael Skater Dress
22263 KILL STAR CLOTHING Bony Skater Dress
22405 KILL STAR CLOTHING(キルスター・クロージング) Idol Sweatshirt
22418 HOLDTUBE HT-2101 A-FIELD SOLID BLACK
22419 HOLDTUBE HT-2104 A-FIELD UNIVERSE
22541 SANTA CRUZ SIEBEN HAND S/S T SHIRT WHITE
22664 ICECREAM BOXED DOG.TEE WHT/PP
22671 ライブキッズあるある チケット探してます 缶バッジ
22672 ライブキッズあるある ヘドバン 缶バッジ
22681 ライブキッズあるある ライブ行きたいTシャツ
23049 Subciety TAPERED WORK PANTS-PAISLEY- BEIGE
23467 ICECREAM ICJP16T001 WHT
23684 SPITFIRE Bighead Grey Spiral Black Rib
23685 SPITFIRE Malt Bighead Black
23705 THRASHER SKATE AND DESTROY WORK SHIRT OD
23776 KILL STAR CLOTHING (キルスター・クロージング) Club 27 Sweatshirt [B}
23779 KILL STAR CLOTHING (キルスター・クロージング) Earthlings Earrings [S]
23801 【ゲキクロ限定】 RIP DESIGN WORXX 手帳型スマホケース HUNGRY LOGO
24104 ANIMALIA ANIMAL-AC34 REEF KNOT RING-BRASS BRASS
24123 ANIMALIA AN16U-AC13 CONCHO RING #001 NATURAL
24124 ANIMALIA AN16U-AC14 CONCHO BANGLE #001 BLACK
24329 RUDIE'S DRAWING-T BLACK
24348 ICECREAM ICJP16T006 WHT
24349 ICECREAM EVIL SUNDAE TEE
24447 GLAMOUR KILLS THE RAINY DAZE RAINCORT
24899 ANIMALIA GOLD WEST WHT
25266 DOCAN! ANARCHY workshirt
25354 REBEL8 WOMENS LO-RISE INDIGO JEAN
25355 REBEL8 WOMENS HI-RISE BLACK JEAN
25396 SQUARE (スクエア) i-PHONE CASE PINUP ALOHA GREEN iPhone6/6s case
25847 Subciety TAPERED WORK PANTS BEIGE
25854 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- BLACK
25855 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- NAVY
27389 THRASHER 16TH-C26 WASH CAP WHITE
27390 THRASHER 16TH-C26 WASH CAP BLACK