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 15:00:21')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
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 / 如意宝珠
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
11162 MEMPHIS MAY FIRE Crest Black Hooded
11210 THE FACELESS Autotheism Hoodie Black
11215 LIKE MOTHS TO FLAMES Demon Black Hoodie
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
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]
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]
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
18984 WE CAME AS ROMANS Varsity Custom Heather Grey Crew
19010 WHITECHAPEL Thirst Black
19014 REVOCATION Deathless Album Black
19063 HOLDTUBE HT-0403 TOUCH FUSION UNIVERSE
19100 ATTILA Guilty Pleasure Black Crewneck
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
21118 WE CAME AS ROMANS Horse & Rider All-Over-Print
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
22786 ANGRY FROG REBIRTH メタルロゴ プルパーカー
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
24655 NECK DEEP Hero Quest Black - Crewneck
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
24700 MEMPHIS MAY FIRE Logo Two Tone - TankTop
24768 NORTHLANE All-Over Print Black - T-Shirt
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
24899 ANIMALIA GOLD WEST WHT
25135 SEAWAY Colour Blind Logo Grey - Pullover
25144 CITY LIGHTS Arrows Black - Crewneck Sweatshirt
25161 WE CAME AS ROMANS Cracked Hope Heather Grey - Crewneck
25188 IWRESTLEDABEARONCE W Paw Black - Long Sleeve Shirt
25228 LIKE MOTHS TO FLAMES TDTWLF Torch Black - Long Sleeve
25266 DOCAN! ANARCHY workshirt
25313 EMAROSA Side Fox Tr-Blend Heather Grey - TankTop
25409 FINCH Flame Blue/White - Baseball Shirt
25449 MAYDAY PARADE Pom Beanie
25484 PIERCE THE VEIL San Diego Navy - Pullover
25854 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- BLACK
25855 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- NAVY
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
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]
28301 UPON A BURNING BODY Logo All Over T-Shirt
28823 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(グレー)
29109 KILL STAR CLOTHING (キルスター・クロージング) Cozmic Death Crop Top [B]
29536 Artemis Classic ミスティックシールドスタッドピアスRD[ACE0132]
29537 Artemis Classic ラージクイッククリップキーホルダー [ACK0039]
29559 Artemis Classic トレサリーブルータイガーアイ数珠ブレス[ACB0100]
29589 ICECREAM ICJP16T034 T-SHIRT GRAY
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)
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]
39558 PARADOX ORACLE L/S TEE (YELLOW)
40491 THRASHER TH8501 MAG LOGO HOODIE NAVY/WHITE
40791 Artemis Classic ACE0142 フェニックススタッドピアス
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]
43822 Artemis Classic ACE0143 ウリエルブリッジピアス
43825 Artemis Classic ACE0144 ウリエルイヤージャケットピアス
43828 Artemis Classic ACE0145 ウリエルWリングイヤカフ