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 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-05-23 02:06:52')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.price02 > 4545
AND price02 <= 9090
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
56572 NineMicrophones 9MC Crew S/S Blue
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
7269 Artemis Classic トレサリースリーピースレザーブレス[ACB0064]
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
13399 ICECREAM FAST DOG TEE SU14 GRAY
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
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
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
19063 HOLDTUBE HT-0403 TOUCH FUSION UNIVERSE
20065 ICECREAM VARSITY GREY
20067 ICECREAM ICEFA HEATHER GREY
20100 KILL STAR CLOTHING PENTAGRAM EARRINGS[P]
20115 KILL STAR CLOTHING RA T-SHIRT [B]
20119 KILL STAR CLOTHING OM TUNIC DRESS [B]
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
20303 REBEL8 GR8FUL TEE
20483 FAR★STAR 百目♀鼠 T&ショートT
20485 FAR★STAR Sperm ショートT フリーサイズ
20751 Subciety BASEBALL TEE 7/S-COLLEGE- GRAY
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
23467 ICECREAM ICJP16T001 WHT
23684 SPITFIRE Bighead Grey Spiral Black Rib
23776 KILL STAR CLOTHING (キルスター・クロージング) Club 27 Sweatshirt [B}
24104 ANIMALIA ANIMAL-AC34 REEF KNOT RING-BRASS BRASS
24124 ANIMALIA AN16U-AC14 CONCHO BANGLE #001 BLACK
24348 ICECREAM ICJP16T006 WHT
24349 ICECREAM EVIL SUNDAE TEE
24899 ANIMALIA GOLD WEST WHT
25266 DOCAN! ANARCHY workshirt
25854 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- BLACK
25855 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- NAVY
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
28046 SPITFIRE Speed Kills T-Shirt - Camo/White
28055 SPITFIRE Bloodshot Premium T-Shirt - Rainbow Tie Dye
28146 KILL STAR CLOTHING (キルスター・クロージング) Dye Fast Dirge Skirt [BLOOD]
28147 KILL STAR CLOTHING (キルスター・クロージング) Dye Fast Dirge Skirt [T/D]
28152 KILL STAR CLOTHING (キルスター・クロージング) iScream Skater Dress [B]
28823 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(グレー)
31647 ANIMALIA AN17S-TE05 RUSTICLOTHES DEPT. olive
33748 ANIMALIA AN17U-AC12 Mobile Battery 4000mAh 17SU BLACK ANCHOR
34032 HOLDTUBE HT-2112 A-FIELD LUNARIUM
34033 HOLDTUBE HT-2111 A-FIELD RED EYE
36268 THRASHER THSR-SST01 BLK
36879 ANIMALIA IQOSR Case (humboldt×ANIMALIA) (ORTEGA)
38525 KILL STAR CLOTHING(キルスター・クロージング) Thumper Gothic Kawaii Hoodie
39533 KILL STAR CLOTHING (キルスター・クロージング) NOTHING Skater Dress [B]
39558 PARADOX ORACLE L/S TEE (YELLOW)
40491 THRASHER TH8501 MAG LOGO HOODIE NAVY/WHITE
40870 HOLDTUBE HT-0424 TOUCH FUSION SHINY BANANA
40871 HOLDTUBE HT-0427 TOUCH FUSION PEACE BLOSSOM
41149 HOLDTUBEHT-2404 FLAP HOLDER PEACE BLOSSOM
41733 SQUARE CLEAR LENS SUNGLASS BLACK
43487 KILL STAR CLOTHING Delish Relaxed Top [B]
47105 NOT COMMON SENSE GENESIS SEAM TEE WHITE
49746 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 戸山香澄ver.
49748 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 牛込りみver.
49763 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Sweat Designed by RIPDW GREEN
49764 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW ORANGE
49765 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW BLUE
49766 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW YELLOW
49767 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW GREEN
50185 SAMURAI CORE SR-TE-07-B SAMURAI CORE tee WHITE
50186 SAMURAI CORE SR-TE-07-B SAMURAI CORE tee BLACK
53068 SAMURAI CORE 地震ー雷ー火事ーオヤジ LONG TEE WHITE
54641 ROLLING CRADLE JUDGEMENT TEE GREEN
54673 FILA FFM9802 ユニセックス クルーネックシャツ WHITE
54674 FILA FFM9802 ユニセックス クルーネックシャツ RED
54675 FILA FFM9802 ユニセックス クルーネックシャツ NAVY
17695 Subciety TIE DYE TANK TOP-GLORIOUS- NAVY
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE
17678 Subciety 15th GLORIOUS S/S BLACK/WHITE
17668 Subciety TIE DYE TEE-GLORIOUS- GREY
23125 Subciety COLLEGE S/S NAVY/WHITE
23124 Subciety COLLEGE S/S BLACK/BURGUNDY
23111 Subciety SALOON S/S NAVY/YELLOW
23090 Subciety(サブサエティ) THRON S/S BLACK
20758 Subciety POCKET TEE S/S-GLORIOUS- GRAY
38026 Subciety (サブサエティ) ザ・ベース S/S WHITE
55652 THRASHER (スラッシャー) TH91214US FLAME OUTLINE S/S T-SHIRTS WHITE/YELLOW
55960 火寺企画 完全無敵のロングスリーブTシャツ BLACK
36703 RUDIE'S (ルーディーズ) KHAOS Mobile Battery
55885 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Baige
55886 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Black
55876 GoneR GR26ZP001 Rose Photo Zip Parka Heather gray
28428 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT BLACK
28821 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(ブラック)
56219 Anti Social Social Club 7734
56220 Anti Social Social Club Sadness Is Happiness
56543 【ゲキクロ限定】PSYCHOLOGICAL METAMORPHOSIS PLMP MULTI LS TEE
56047 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(Blk)
56049 【ゲキクロ限定】KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(ゲキクロ限定カラー)
56517 水野ギイ×RIPDW×GEKIROCK CLOTHINGコラボ・ロンT PURPLE
57226 Artemis Classic トレサリー天然ラピス数珠ブレス[ACB0118]
57227 Artemis Classic ラピスワックスコードシングルブレス[ACB0119]
57228 Artemis Classic オニキスワックスコードWブレスACB0120]
57231 Artemis Classic フローラルカラビナキーホルダーパイソン[ACLK0024]