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-04-28 05:09:12')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
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
46450 Zephyren(ゼファレン)BIG TANKTOP BLACK / 如意宝珠
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
9891 KILL STAR CLOTHING GRUMPY SWEATSHIRT
11162 MEMPHIS MAY FIRE Crest Black Hooded
11210 THE FACELESS Autotheism Hoodie Black
11215 LIKE MOTHS TO FLAMES Demon Black Hoodie
11285 Nine Microphones BE ON STAGE S/S BLACK
15410 MEMPHIS MAY FIRE Skulls & Arrows Black Crewneck
15481 ATTILA Kings Black Crewneck
16590 KILL STAR CLOTHING KABBALAH HOOD DRESS [B]
16592 KILL STAR CLOTHING MOONCHILD SKATER DRESS [B]
16983 ZEPHYREN (ゼファレン) TANK TOP -BONEYARD- - BLACK
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
19010 WHITECHAPEL Thirst Black
19014 REVOCATION Deathless Album Black
19100 ATTILA Guilty Pleasure Black Crewneck
20115 KILL STAR CLOTHING RA T-SHIRT [B]
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
20303 REBEL8 GR8FUL TEE
20483 FAR★STAR 百目♀鼠 T&ショートT
20485 FAR★STAR Sperm ショートT フリーサイズ
22095 FUZZ REZ ZWEEP DELAY LONG SLEEVE TEE BLK
22098 FUZZ REZ ZWEEP MODULATION TEE BLK
22102 FUZZ REZ ZWEEP BIT CRUSHER TEE BLK
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
22786 ANGRY FROG REBIRTH メタルロゴ プルパーカー
23776 KILL STAR CLOTHING (キルスター・クロージング) Club 27 Sweatshirt [B}
24124 ANIMALIA AN16U-AC14 CONCHO BANGLE #001 BLACK
24655 NECK DEEP Hero Quest Black - Crewneck
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
25144 CITY LIGHTS Arrows Black - Crewneck Sweatshirt
25188 IWRESTLEDABEARONCE W Paw Black - Long Sleeve Shirt
25228 LIKE MOTHS TO FLAMES TDTWLF Torch Black - Long Sleeve
25266 DOCAN! ANARCHY workshirt
25449 MAYDAY PARADE Pom Beanie
25854 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- BLACK
26144 ARCHITECTS Daybreaker Crewneck
26152 I KILLED THE PROM QUEEN Monogram Zip Hoodie
26230 OPETH Morningrise Hoodie
26281 DROPKICK MURPHYS Drinking Skeleton Cross Zip Hood
27377 DEEZ NUTS Bout It Sweatshirt
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
28147 KILL STAR CLOTHING (キルスター・クロージング) Dye Fast Dirge Skirt [T/D]
28152 KILL STAR CLOTHING (キルスター・クロージング) iScream Skater Dress [B]
28301 UPON A BURNING BODY Logo All Over T-Shirt
29109 KILL STAR CLOTHING (キルスター・クロージング) Cozmic Death Crop Top [B]
29536 Artemis Classic ミスティックシールドスタッドピアスRD[ACE0132]
29559 Artemis Classic トレサリーブルータイガーアイ数珠ブレス[ACB0100]
33748 ANIMALIA AN17U-AC12 Mobile Battery 4000mAh 17SU BLACK ANCHOR
34032 HOLDTUBE HT-2112 A-FIELD LUNARIUM
36268 THRASHER THSR-SST01 BLK
37272 KILL STAR CLOTHING(キルスター・クロージング) Obscura Fuzzy Knit Sweater [B]
38525 KILL STAR CLOTHING(キルスター・クロージング) Thumper Gothic Kawaii Hoodie
39531 KILL STAR CLOTHING Tryals Cast-Out Vest Top [B]
39533 KILL STAR CLOTHING (キルスター・クロージング) NOTHING Skater Dress [B]
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]
44814 KILL STAR CLOTHING Ceremony Flat [B]
44826 KILL STAR CLOTHING Spook N Destroy Knit Sweater [B]
44832 KILL STAR CLOTHING Keiko Kitty Flats [B]
44862 ROB ZOMBIE×KILL STAR CLOTHING Baby Death Skater Skirt
45714 KILL STAR CLOTHING Feri Doll Dress
46250 SABBAT13 SBT-LT-020 13X-BONE L/S T (ブラック)
46263 SABBAT13 SBT-LT-022 D.D.T.W L/S T(ブラック)
47103 NOT COMMON SENSE FUXX THE POLICE SEAM TEE BLACK
48183 KILL STAR CLOTHING Under The Stars Skater Skirt
48280 BLACK CRAFT Moon Child - Wristlet
49071 HOLDTUBE HT-0435 TOUCH FUSION DEEP WARP2
49213 KILL STAR CLOTHING Omen Kimono Dress [B]
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
50186 SAMURAI CORE SR-TE-07-B SAMURAI CORE tee BLACK
50818 CHORD NUMBER EIGHT CH01-01K5-AC07 JACQUARD TAPE NECKLACE BLACK&BLACK
51360 KILL STAR CLOTHING Descent Handbag
51362 KILL STAR CLOTHING Diablerie T-Shirt
51367 KILL STAR CLOTHING Grim Moon Leggings
51368 KILL STAR CLOTHING Umbra Leggings
51376 極東ロマンス×acOlaSia ゲキクロ限定コラボ L/S T-Shirt
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
53927 KEYTALK 丁寧な刺繍パーカー パープル
53928 KEYTALK 丁寧な刺繍パーカー ブラック
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE
17678 Subciety 15th GLORIOUS S/S BLACK/WHITE
23124 Subciety COLLEGE S/S BLACK/BURGUNDY
23090 Subciety(サブサエティ) THRON S/S BLACK
55808 SUBLIME×SULLEN HEAD HIGH STANDARD TANKTOP
54046 NOT COMMON SENSE ”KC ALTERNATIVE SOUND” TEE 03
55960 火寺企画 完全無敵のロングスリーブTシャツ BLACK
36703 RUDIE'S (ルーディーズ) KHAOS Mobile Battery
55886 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Black
28428 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT BLACK
28821 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(ブラック)
56543 【ゲキクロ限定】PSYCHOLOGICAL METAMORPHOSIS PLMP MULTI LS TEE
35616 GUNS N' ROSES CLASSIC LOGO PULLOVER
56759 AC/DC UNISEX PULLOVER HOODIE: CANNON SWIG
56760 AC/DC LADIES ZIPPED HOODIE: LOGO (BACK PRINT)
56047 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(Blk)
56049 【ゲキクロ限定】KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(ゲキクロ限定カラー)
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
57227 Artemis Classic ラピスワックスコードシングルブレス[ACB0119]
57228 Artemis Classic オニキスワックスコードWブレスACB0120]
57231 Artemis Classic フローラルカラビナキーホルダーパイソン[ACLK0024]
56385 Subciety (サブサエティ) BEANIE-SERVER - BLACK
56762 RAMONES UNISEX PULLOVER HOODIE: PRESIDENTIAL SEAL
56919 Half time Old×GEKIROCK CLOTHING 限定コラボ・パーカー
56757 エルフリーデ×ゲキクロ×DI:VISION限定ロング・スリーブTシャツBLACK/RED
57391 FILA FS3008 T-Shirt BLACK
57421 THRASHER (スラッシャー) TH8428PLGONZ SWEAT BLACK