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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-24 06:22:36')
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` = 7
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 240
66499 10-FEET×Zephyren(ゼファレン) DOLMAN BIG TEE WHITE
53186 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SMILEY
71646 青空フミ×GALFY×ゲキクロ コラボTシャツ BLUE
71741 青空フミ×GALFY×ゲキクロ コラボTシャツ WHITE
71742 青空フミ×GALFY×ゲキクロ コラボTシャツ BLACK
65622 やね×GALFY×GEKIROCK CLOTHING やねの犬Tシャツ BLACK
65624 やね×GALFY×GEKIROCK CLOTHING やねの犬Tシャツ WHITE
68781 里塚 賢汰×CIVARIZE コラボ限定オーバーサイズTシャツ
68917 EMPATHY×over print Tシャツ PURPLE
68970 EMPATHY×over print Tシャツ L.BLUE
70369 Appare!×GALFY×GEKIROCK CLOTHING コラボ・Tシャツ WHITE
70837 Appare!×GALFY×GEKIROCK CLOTHING コラボ・Tシャツ BLACK
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
68770 やまもとひかる×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・Tシャツ PURPLE
68771 やまもとひかる×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・Tシャツ WHITE
68784 美園 礼音 × LONELY論理 コラボ限定Tシャツ
68787 曙 涼×NOT COMMON SENSEコラボ限定Tシャツ
70350 chuLa × scene tokyo コラボ・Tシャツ BLACK プリントPINK
70351 chuLa × scene tokyo コラボ・Tシャツ BLACK プリントMINT
70352 chuLa × scene tokyo コラボ・Tシャツ BLACK プリントRED
70353 chuLa × scene tokyo コラボ・Tシャツ BLACK プリントORANGE
70354 chuLa × scene tokyo コラボ・Tシャツ BLACK プリントBLUE
70356 chuLa × scene tokyo コラボ・Tシャツ BLACK プリントYELLOW
70357 chuLa × scene tokyo コラボ・Tシャツ BLACK プリントWHITE
70358 chuLa × scene tokyo コラボ・Tシャツ BLACK プリントPURPLE
70359 chuLa × scene tokyo コラボ・Tシャツ WHITE プリントPURPLE
70360 chuLa × scene tokyo コラボ・Tシャツ WHITE プリントWHITE
70361 chuLa × scene tokyo コラボ・Tシャツ WHITE プリントYELLOW
70362 chuLa × scene tokyo コラボ・Tシャツ WHITE プリントBLUE
70363 chuLa × scene tokyo コラボ・Tシャツ WHITE プリントORANGE
70364 chuLa × scene tokyo コラボ・Tシャツ WHITE プリントRED
70438 chuLa × scene tokyo コラボ・Tシャツ WHITE プリントMINT
70439 chuLa × scene tokyo コラボ・Tシャツ WHITE プリントPINK
70484 神薙ラビッツ×アマツカミ× GEKIROCK CLOTHINGコラボ・Tシャツ 桃色
70488 神薙ラビッツ×アマツカミ× GEKIROCK CLOTHINGコラボ・Tシャツ 水色
70489 神薙ラビッツ×アマツカミ× GEKIROCK CLOTHINGコラボ・Tシャツ 橙色
71566 【予約商品】UNBS(ex.アンダービースティー)×アマツカミ×GEKIROCK CLOTHING限定コラボ・Tシャツ
24768 NORTHLANE All-Over Print Black - T-Shirt
65688 Lonesome_Blue×KAVANE Clothing×GEKIROCK CLOTHINGコラボ・Tシャツ
66802 THE SILENT DOG × GEKIROCK CLOTHING × NOTBADCAT 限定コラボ T-Shirt WHITE
66803 THE SILENT DOG × GEKIROCK CLOTHING× NOTBADCAT 限定コラボ T-Shirt BLACK
67412 福島ノア × DI:VISION コラボ限定Tシャツ
67874 白石万浬 × DI:VISION コラボ限定Tシャツ
69459 NAKAYOSHI FES.2023×over print×GEKIROCK CLOTHING スペシャル・コラボ・Tシャツ BLACK
70059 Risky Melody×RIP DESIGN WORXX×GEKIROCK CLOTHING コラボ・Tシャツ
70441 明石真秀×RUDIE'S コラボ限定Tシャツ
70455 月見山 渚×アマツカミ コラボ限定Tシャツ
70609 木下百花×ヤツキナツミ×GEKIROCK CLOTHING コラボ・Tシャツ WHITE
71086 月に足跡を残した6人の少女達は一体何を見たのか...×アマツカミ×GEKIROCK CLOTHING スペシャル・コラボ・Tシャツ
67922 【BanG Dream! ×ゲキクロ 2023 ver.】氷川紗夜×Subciety コラボ Tシャツ
68004 【BanG Dream! ×ゲキクロ 2023 ver.】パレオ×DI:VISION コラボ Tシャツ
68008 【BanG Dream! ×ゲキクロ 2023 ver.】湊友希那×ZEPHYREN コラボ Tシャツ
68012 【BanG Dream! ×ゲキクロ 2023 ver.】今井リサ×RIP DESIGN WORXX コラボ Tシャツ
28301 UPON A BURNING BODY Logo All Over T-Shirt
21118 WE CAME AS ROMANS Horse & Rider All-Over-Print
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
57798 CRADLE OF FILTH Krampus T-shirt + ornament
63258 沢城千春×SABBAT13×GEKIROCK CLOTHING Lying T-Shirt WHITE
63259 沢城千春×SABBAT13×GEKIROCK CLOTHING Lying T-Shirt BLACK
63260 沢城千春×SABBAT13×GEKIROCK CLOTHING Stand T-Shirt ORANGE
63261 沢城千春×SABBAT13×GEKIROCK CLOTHING Stand T-Shirt PURPLE
58063 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT
58064 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TILT
58065 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TAPED
58513 DESURABBITS × ゲキクロ × KAVANE Clothing 限定コラボ・Tシャツ
63364 KEYTALK【Disney】Tシャツ (ステージ) WHITE
63365 KEYTALK【Disney】Tシャツ (ステージ) BLACK
63367 KEYTALK【Disney】Tシャツ (縦割り) BLACK
585 RED HOT CHILI PEPPERS Asterisk Logo Black
700 METALLICA-KILL EM ALL
1097 RED HOT CHILI PEPPERS Asterisk Logo White
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
4598 NIRVANA Happy Face T-Shirt
4599 NIRVANA MANY Happy Face T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
8372 FALLING IN REVERSE Lips T-Shirt BLACK
10233 METALLICA DORIS T-Shirt
10235 METALLICA VINTAGE METAL UP T-Shirt
10258 GUNS N' ROSES CROSS T-Shirt
11984 ANTHRAX WORSHIP MUSIC T-Shirt
12020 EVANESCENCE SHINE T-Shirt
17951 AVENGED SEVENFOLD STELLAR
24672 SLEEPING WITH SIRENS Floral Black - T-Shirt
25492 THE SUMMER SET Perfectly Wasted Youth White - T-Shirt
28592 MARILYN MANSON CROWN T-Shirts
28694 AUGUST BURNS RED DOVE
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
35620 GUNS N' ROSES BIG GUNS T-SHIRTS
35642 MARILYN MANSON RED LIPS T-SHIRTS
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
35655 PANTERA Red Vulgar T-Shirts
36663 GUNS N' ROSES BULLET LOGO
36830 GREEN DAY American Idiot Black T-shirt
37810 BULLET FOR MY VALENTINE Logo T-shirt Black
37811 ALL TIME LOW UNISEX TEE: SCRATCH
41960 BABYMETAL Unisex Tee: Skull Sword
43345 BRING ME THE HORIZON Sempiternal TEE
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
45953 Crossfaith ORNAMENT TEE BLACK
49512 SLIPKNOT .5 THE GRAY CHAPTER
51199 SLIPKNOT UNISEX TEE: WANYK LOGO (BACK PRINT)
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
51425 GREEN DAY Unisex Tee: Drips
51426 GREEN DAY Unisex Tee: Hypno 4
52510 BILLIE EILISH UNISEX TEE GRAFFITI WHITE
52511 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) LIME GREEN
52513 BILLIE EILISH UNISEX TEE AGONY BLACK
52713 BABYMETAL UNISEX TEE: LOGO
52866 BILLIE EILISH UNISEX TEE AGONY WHITE
52867 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) PINK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52869 BILLIE EILISH UNISEX TEE: BLING BLACK
52870 BILLIE EILISH UNISEX TEE: BLING WHITE
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
52907 KORN UNISEX TEE: DEATH DREAM
52928 RAGE AGAINST THE MACHINE UNISEX TEE: MOTOTOV (BACK PRINT)
53184 ALL TIME LOW UNISEX TEE: DA BOMB
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
53189 BLACK VEIL BRIDES UNISEX TEE: INFERNO
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
53874 MY CHEMICAL ROMANCE COFFIN T-Shirts
54740 ANTHRAX UNISEX TEE: AMONG THE LIVING
54741 ANTHRAX UNISEX TEE: STATE OF EUPHORIA
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55732 SLAYER UNISEX TEE: REPENTLESS
55734 SLAYER UNISEX TEE: SILVER EAGLE
56810 AC/DC UNISEX TEE: ANGUS STATUE
56811 AC/DC UNISEX FASHION TEE: BLACK ICE (BURN OUT)
56820 THE 1975 UNISEX TEE: BLACK TOUR
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59253 NIRVANA Unisex Tee:Xerox Happy Face Pink
59255 NIRVANA Unisex Tee:White Happy Face
59257 NINE INCH NAILS Unisex Tee: Classic Logo
59258 Kurt Cobain Unisex Tee: Coloured Side View
59264 Ed Sheeran Unisex Tee: Dashed Stage Photo
59265 Ed Sheeran Unisex Tee: Chords
59266 Ed Sheeran Unisex Tee: Divide
59273 IRON MAIDEN Unisex Tee: Eddie Chained Legacy
59274 IRON MAIDEN Unisex Tee: Duality
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
59278 BABYMETAL PENTAGRAM TEE
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
60189 MY CHEMICAL ROMANCE MY CHEMICAL ROMANCE UNISEX T-SHIRT: THE BLACK PARADE COVER
60191 MARILYN MANSON UNISEX T-SHIRT: WE ARE CHAOS (BACK PRINT)
60192 RED HOT CHILI PEPPERS UNISEX T-SHIRT: GETAWAY ALBUM ASTERISK
60194 TWENTY ONE PILOTS UNISEX T-SHIRT: BANDITO BIRD
60195 TWENTY ONE PILOTS UNISEX T-SHIRT: TRENCH CLIFF
60196 TWENTY ONE PILOTS UNISEX T-SHIRT: TORCH BEARERS
66941 BAD RELIGION UNISEX T-SHIRT: BURNING BLACK
66944 KORN UNISEX T-SHIRT: BLOCKS
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
66966 MEGADETH UNISEX T-SHIRT: RUST IN PEACE 30TH ANNIVERSARY (BACK PRINT)
66967 MEGADETH UNISEX T-SHIRT: KILLING IS MY BUSINESS (BACK PRINT)
66968 MEGADETH UNISEX T-SHIRT: PEACE SELLS… TRACK LIST (BACK PRINT)
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
67506 SUM41 UNISEX T-SHIRT: GRINNING SKULL
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
67934 BRING ME THE HORIZON UNISEX T-SHIRT: ZOMBIE HANDS
67940 BRING ME THE HORIZON UNISEX T-SHIRT: WARRIOR
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
67954 FALL OUT BOY UNISEX T-SHIRT: POISONED YOUTH
67955 KORN UNISEX T-SHIRT: BLOCK PHOTO
67956 KORN UNISEX T-SHIRT: STILL A FREAK (BACK PRINT)
67957 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY BLACK
67958 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY WHITE
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
67965 MARILYN MANSON UNISEX T-SHIRT: AMERICAN FAMILY (BACK PRINT)
67966 NIRVANA UNISEX T-SHIRT: ANGELIC
67967 NIRVANA UNISEX T-SHIRT: SORBET RAY Happy Face
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
67974 YUNGBLUD LADIES T-SHIRT: RAVER SMILE (BACK PRINT)
67975 YUNGBLUD UNISEX T-SHIRT: FACE (BACK PRINT)
67976 YUNGBLUD UNISEX T-SHIRT: WEIRD FLAMING SKELETONS (BACK PRINT)
67977 YUNGBLUD UNISEX T-SHIRT: R-U-OK?
68568 GREEN DAY UNISEX T-SHIRT: FLOWER POT (WASH COLLECTION)
68569 GREEN DAY UNISEX T-SHIRT: DOOKIE LONGVIEW (WASH COLLECTION)
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
68572 IRON MAIDEN UNISEX T-SHIRT: THE FUTURE PAST TOUR '23 GREYSCALE
68573 KORN UNISEX T-SHIRT: REQUIEM ALBUM COVER (BACK PRINT)
68574 KORN UNISEX HI-BUILD T-SHIRT: LOGO
68575 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO BLACK
68576 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO WHITE
68577 LINKIN PARK UNISEX T-SHIRT: LIVING THINGS ALBUM
68578 MY CHEMICAL ROMANCE UNISEX T-SHIRT: SPIDER
68579 NIRVANA UNISEX T-SHIRT: HEART (WASH COLLECTION)
68580 SLIPKNOT UNISEX T-SHIRT: ALIEN (BACK PRINT)
68581 SLIPKNOT UNISEX T-SHIRT: SKELETON & PENTAGRAM (BACK PRINT)
68582 SLIPKNOT UNISEX T-SHIRT: ADDERALL FACEBACK (BACK PRINT)
68583 SLIPKNOT UNISEX T-SHIRT: THE END (BACK PRINT)
68584 SYSTEM OF A DOWN UNISEX T-SHIRT: TOXICITY
68585 SYSTEM OF A DOWN UNISEX T-SHIRT: TRIPLE STACK BOX
68586 SYSTEM OF A DOWN UNISEX T-SHIRT: BANNER MARCHES
68831 BRING ME THE HORIZON UNISEX T-SHIRT: BARBED WIRE (BACK PRINT)
68833 SLIPKNOT UNISEX T-SHIRT: ZOMBIE (BACK PRINT)
68835 SLIPKNOT UNISEX T-SHIRT: DEVIL SINGLE - LOGO BLUR (BACK PRINT)
68839 SLIPKNOT UNISEX T-SHIRT: AMUSEMENT PARK (BACK PRINT)
69157 METALLICA UNISEX T-SHIRT: AND JUSTICE FOR ALL TRACKS (BACK PRINT)
69158 DEF LEPPARD UNISEX T-SHIRT: CLASSIC TRIANGLE
69159 DEF LEPPARD UNISEX T-SHIRT: TRIANGLE LOGO
69160 DEF LEPPARD UNISEX T-SHIRT: SHATTER
69161 DEF LEPPARD UNISEX T-SHIRT: HYSTERIA WORLD TOUR (BACK PRINT)
69162 MOTLEY CRUE UNISEX T-SHIRT: TOO FAST CYCLE
69163 MOTLEY CRUE UNISEX T-SHIRT: FEELGOOD HOLLYWOOD REVISION
69164 MOTLEY CRUE UNISEX T-SHIRT: THEATRE OF PAIN CRY
69165 MOTLEY CRUE UNISEX T-SHIRT: BAD BOYS SHIELD
69354 BRING ME THE HORIZON UNISEX T-SHIRT: FLAMING HEX BLACK
69356 BAD OMENS UNISEX T-SHIRT: RAM SKULL BLACK
69441 BRING ME THE HORIZON UNISEX T-SHIRT: LOST (BACK PRINT)
69442 BRING ME THE HORIZON UNISEX T-SHIRT: ALL HAIL (BACK PRINT)
69443 BRING ME THE HORIZON UNISEX T-SHIRT: NEX GEN COVER
69444 BRING ME THE HORIZON UNISEX T-SHIRT: DISTRESSED NEX GEN
69445 BRING ME THE HORIZON UNISEX T-SHIRT: GREEN NEX GEN
69446 BRING ME THE HORIZON UNISEX T-SHIRT: IMPRINT NEX GEN
69765 BAD OMENS UNISEX T-SHIRT: TAKE ME
70278 BULLET FOR MY VALENTINE UNISEX T-SHIRT: THRASH SKULL
70279 BULLET FOR MY VALENTINE UNISEX T-SHIRT: FLORAL OMEN
70280 BULLET FOR MY VALENTINE UNISEX T-SHIRT: RAM (BACK PRINT)
70554 BRING ME THE HORIZON UNISEX T-SHIRT: WHY...?
70557 SUM41 UNISEX T-SHIRT: REAPER
70561 SUM41 UNISEX T-SHIRT: DOES THIS LOOK LIKE ALL KILLER NO FILLER EUROPEAN TOUR 20
70685 LINKIN PARK UNISEX T-SHIRT: METEORA PORTRAITS
70686 LINKIN PARK UNISEX T-SHIRT: SHIFT
70819 POLYPHIA UNISEX T-SHIRT: RITUAL
70820 POLYPHIA UNISEX T-SHIRT: SKULL CIRCLE P