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 23:11:44')
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
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 `category_type` IS NULL
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
62577 METALLICA FADE TO BLACK SKATE BAG
60744 ガリュウホンポ 丑袖切ジップパーカー
51173 brokker “METALLICA” フィギュア
62575 SLAYER REPEATED BACKPACK
62576 METALLICA FADE TO BLACK DAYPACK BACKPACK
62584 MARILYN MANSON LOGO BACKPACK
62592 IRON MAIDEN TROOPER BACKPACK
62593 MY CHEMICAL ROMANCE PARADE BACKPACK
62594 AC/DC POWER UP DAYPACK BACKPACK
36658 FIVE FINGER DEATH PUNCH WAY OF THE FIST Backpack
62581 METALLICA LIGHTNING SHOULDER BAG
24561 PROTEST THE HERO Crest Logo Forest Green - Snapback Hat
24751 WHITECHAPEL Strike Through Army Green - 5 Panel
26293 DROPKICK MURPHYS Lets Go Scarf
62579 METALLICA FADE TO BLACK CROSSBODY BAG
62580 METALLICA KILL EM ALL CROSS BODY BAG
62583 MARILYN MANSON RED LIPS CROSSBODY BAG
62595 AC/DC POWER UP CROSSBODY BAG
62596 BLINK-182 SMILEY CROSSBODY BAG
62597 IRON MAIDEN LOGO CROSSBODY BAG
15362 TONIGHT ALIVE 13 Navy Red Snapback
25494 THE WORD ALIVE REAL Black - Snapback
26190 BAD RELIGION BR Logo Snapback
41048 OBEY x Misfits Fiend Club 6 Panel Hat BLACK
15487 ATTILA Crosses Logo Black Snapback Hat
14605 SLIPKNOT ALLOVERSTAR FLAT BRIM HAT
14606 SLIPKNOT STAR PATTERN BASEBALL HATS
34519 NIRVANA Happy Face & Logo Tote Bag
34521 ROLLING STONES EvonesEvolution Cotton Tote Bag
15340 WHITECHAPEL Sawblade Black Snapback Hat
15534 MAYDAY PARADE Arrow Black / Red Snapback
24701 MEMPHIS MAY FIRE Logo Black - White Brim Snapback
25155 WE CAME AS ROMANS WCAR Black - Snapback
25160 WE CAME AS ROMANS Crest Black / Red - Snapback
25178 ERRA Circle Logo Black - Snapback Hat
25192 IWRESTLEDABEARONCE Logo Black - Snapback
25449 MAYDAY PARADE Pom Beanie
26203 BEASTIE BOYS Check Your Head Snapback
26206 BEHEMOTH Logo Snapback Hat
19838 LIKE MOTHS TO FLAMES FLAMES CAMO SNAPBACK
19871 YELLOWCARD LOGO BLACK/GREEN BRIM
39169 LINKIN PARK Logo Snapback
26154 PARKWAY DRIVE Coffin Snapback
26169 PARKWAY DRIVE Ocean Palms Snapback Hat
49832 SLIPKNOT Logo-Beach Towel
62598 MY CHEMICAL ROMANCE PARADE TRAVEL BAG
62574 SLAYER PATTERN WALLET
62578 METALLICA FADE TO BLACK WALLET
62582 MARILYN MANSON LOGO WALLET
62599 MY CHEMICAL ROMANCE PARADE WALLET
62600 AC/DC POWER UP WALLET
62601 BLINK-182 LOGO WALLET
26462 THE GHOST INSIDE Los Angeles Purple/Gold Flat Brim
49857 FIVE FINGER DEATH PUNCH BRASS ENAMEL PIN Cap
15482 ATTILA Crosses Logo Black
15488 PROTEST THE HERO Stacked Script Logo gray cap
19897 POLYPHIA Logo Black Beanie
24895 NORTHLANE Square Logo Black - Cuffed Beanie
26173 PARKWAY DRIVE PWD Black-Gray Beanie
49854 FIVE FINGER DEATH PUNCH TRIFOLD CHAIN Wallet
52904 MARILYN MANSON PENDANT: T CROSS NECKLACE
54094 SUICIDAL TENDENCIES x MxMxM “MAGICAL TENDENCIES” MESH CAP BLACK
54095 SUICIDAL TENDENCIES x MxMxM “MAGICAL TENDENCIES” MESH CAP DOKU
56814 AC/DC UNISEX BEANIE HAT: OVAL LOGO (CABLE-KNIT)
56815 AC/DC TURNTABLE SLIPMAT SET: LET THERE BE ROCK/ROCK & ROLL (RETAIL PACK)
71316 MÅNESKIN UNISEX MESH BACK CAP: LOUD KIDS ON TOUR
14609 SLIPKNOT SCRATCHED GROUP CHAIN WALLET
37750 SUICIDAL TENDENCIES 2HTSTOG SUICIDAL MESH FLIP ST POSSESSED
41046 OBEY x Misfits Legacy Beanie BLACK
41047 OBEY x Misfits Fiend Club Beanie BLACK
28697 METALLICA DISTRESSED LOGO Cap
36654 BULLET FOR MY VALENTINE 3D LOGO
50182 LINKIN PARK Logo Beanie
5582 SLIPKNOT LOGO Wallet
13792 KORN LOGO Wallet
17971 KILLSWITCH ENGAGE DRAGON ZOMBIE WALLET
36664 GUNS N' ROSES APPETITE LOGO Beanie
36665 GUNS N' ROSES BULLET LOGO Beanie
36671 IRON MAIDEN LOGO Cadet Cap
36674 KORN (RED LOGO) Beanie
36696 SLAYER PENTAGRAM Beanie
51190 SLIPKNOT UNISEX FINGERLESS GLOVES: LOGO
10476 SUICIDAL TENDENCIES x INFECTIOUS GROOVES MESH CAP
10477 SUICIDAL TENDENCIES MESH CAP SKATES WHITE
25152 WE CAME AS ROMANS WCAR Black - Winter Beanie
26130 BRING ME THE HORIZON Sempiternal Tote bag
59267 BULLET FOR MY VALENTINE LOGO CAP
36660 GREEN DAY GREEN DAY LOGO Beanie
17970 KILLSWITCH ENGAGE DRAGON CREST Cap
13902 BULLET FOR MY VALENTINE SKULL AND STRIDES Wallet
26192 BAD RELIGION Crossbuster Tote Bag
26269 DESCENDENTS Milo Snapback Hat
26450 JIMMY EAT WORLD LOGO BEANIE
26459 SLEEPING WITH SIRENS Patch Beanie
26463 THE GHOST INSIDE Endangered Patch Beanie
28587 SLIPKNOT LOGO Beanie
28615 ROLLING STONES GRAY CLASSIC
28616 ROLLING STONES 50TH LOGO Cap
28708 SLAYER BLACK EAGLE Wallet
52515 MARILYN MANSON WRIST STRAP LOGO
24744 WHITECHAPEL Grey / White Sawblade Black - Beanie
24746 WHITECHAPEL Sawblade Black - Socks
28692 KORN PLASTIC LOGO Beanie
28720 BRING ME THE HORIZON THIS IS Beanie
37040 PANTERA Logo Beanie Black
43353 BRING ME THE HORIZON HORROR LOGO BEANIE
43357 BRING ME THE HORIZON Sempiternal BASEBALL CAP
51191 SLIPKNOT TURNTABLE SLIPMAT SET: THE GRAY CHAPTER
61676 Ed Sheeran UNISEX BASEBALL CAP: TYPE LOGO
32273 【ゲキクロ限定】 a crowd of rebellion Xanthium Tour 2017 冬季講習 ロングTシャツ
34352 a crowd of rebellion 10th Anniversary Tour 2017 Mobile Battery
34354 a crowd of rebellion 10th Anniversary Tour 2017 Smart Phone Case Black
34355 a crowd of rebellion 10th Anniversary Tour 2017 Smart Phone Case Pink
19011 WHITECHAPEL Strikethrough Logo Black
19012 WHITECHAPEL Flag Grey Patch
13903 LINKIN PARK GOTHIC LOGO WALLET
51428 GREEN DAY Pendant: Grenade
15406 MEMPHIS MAY FIRE Unconditional Black
25462 OF MICE & MEN Shell Gold - Necklace
35529 BULLET FOR MY VALENTINE LOGO BEANIE