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-02 00:29:23')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 733)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
52575 MARILYN MANSON UNISEX ZIPPED HOODIE: CROSS LOGO (EX TOUR/BACK PRINT)
52946 Survive Said The Prophet CONCRETE COACH JKT WHITE
70709 Survive Said The Prophet SPARKLE COACH JACKET
39171 KORN Baby Hoody
57297 SLIPKNOT UNISEX PULLOVER HOODIE: CHOIR (BACK PRINT)
35284 SLIPKNOT Slipknot Men's Hooded Top: Skull Teeth
36789 SLIPKNOT Gray Chapter Skeleton Hooded Sweatshirt
51194 SLIPKNOT UNISEX PULLOVER HOODIE: GRAPHIC GOAT (BACK PRINT)
51195 SLIPKNOT UNISEX PULLOVER HOODIE: SPLATTER (BACK PRINT)
52592 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO & STAR (APPLIQUE MOTIFS)
52995 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO (BACK PRINT)
66943 KORN UNISEX PULLOVER HOODIE: REQUIEM (BACK PRINT)
70708 Survive Said The Prophet MAKE / BREAK TOUR HOODIE
36791 KORN Shield Zip Hoodie
36811 SLIPKNOT Embroidered and Applique-Authentic Basketball Jersey
36808 SLIPKNOT Logo on Front Pentagram Group on Back Black Button Down
62570 Survive Said The Prophet REDEFINE TOUR HOODIE BLACK
62571 Survive Said The Prophet REDEFINE TOUR HOODIE WHITE
52593 SLIPKNOT UNISEX LONG SLEEVED TEE: SHROUDED GROUP (BACK & ARM PRINT)
52996 SLIPKNOT UNISEX LONG SLEEVED TEE: SUBLIMINAL VERSES (BACK & ARM PRINT)
14605 SLIPKNOT ALLOVERSTAR FLAT BRIM HAT
14606 SLIPKNOT STAR PATTERN BASEBALL HATS
36544 SLIPKNOT Distressed Group Room Longsleeve
70710 Survive Said The Prophet EAR FLAP CAP
70711 Survive Said The Prophet SurvivE L/S TEE(Glow-in-the-dark)
14114 SLIPKNOT SICKNESS TEE
49832 SLIPKNOT Logo-Beach Towel
70718 Survive Said The Prophet SHAPES L/S TEE
26176 SUICIDE SILENCE Inhert L/S
35289 SLIPKNOT UNISEX T-SHIRT: BAND FRAME
35295 SLIPKNOT WAVES
35635 KORN SKULLDELIS T-SHIRTS
35637 KORN STAGE T-SHIRTS
35642 MARILYN MANSON RED LIPS T-SHIRTS
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
36862 SLIPKNOT Infection Green Longsleeve t-shirt
45953 Crossfaith ORNAMENT TEE BLACK
49512 SLIPKNOT .5 THE GRAY CHAPTER
51199 SLIPKNOT UNISEX TEE: WANYK LOGO (BACK PRINT)
51202 SLIPKNOT UNISEX TEE: WANYK BACK HIT (BACK PRINT)
52907 KORN UNISEX TEE: DEATH DREAM
52908 KORN UNISEX TEE: SCRATCHED TYPE (BACK PRINT)
52997 SLIPKNOT UNISEX TEE: TORN APART (BACK PRINT)
17752 a crowd of rebellion The Crow Hoodie
35286 SLIPKNOT Long Sleeved Tee: Blocks
51193 SLIPKNOT UNISEX FASHION TEE: LOGO & STAR (APPLIQUE MOTIFS)
52904 MARILYN MANSON PENDANT: T CROSS NECKLACE
49850 MARILYN MANSON HOLLYWOOD
49851 MARILYN MANSON KILL FOR ME
14609 SLIPKNOT SCRATCHED GROUP CHAIN WALLET
35291 SLIPKNOT Masks 2
35505 SLIPKNOT Fuck Me UpT-Shirt
35511 SLIPKNOT Prepare for Hell 2014-2015 Tour
51200 SLIPKNOT UNISEX TEE: WANYK RED PATCH (BACK PRINT)
51201 SLIPKNOT UNISEX TEE: WANYK ORANGE (BACK PRINT)
70714 Survive Said The Prophet MAKE / BREAK TEE (BLACK)
70715 Survive Said The Prophet MAKE / BREAK TEE (WHITE)
14103 SLIPKNOT THORNS ALL OVER T-Shirt
36778 SLIPKNOT Prepare For Hell 2015 Tour Backprint-Black t-shirt
49830 SLIPKNOT US Flag 2015-North American Tour-Black t-shirt
49831 SLIPKNOT Windows - Black t-shirt
39172 KORN Face in the Fire Tanktop
39173 KORN Asthma Tee
39174 KORN Cracked Glass Tee
5577 MARILYN MANSON SKULL CROSS T-Shirt
5579 SLIPKNOT MASK HELL T-Shirt
5582 SLIPKNOT LOGO Wallet
13791 SLIPKNOT STAR CREST T-Shirt
13792 KORN LOGO Wallet
14116 KORN DEATH DEREAM MENS TEE
17821 MARILYN MANSON Oversaturated Photo
26174 SUICIDE SILENCE Stronger Than Faith
26177 SUICIDE SILENCE WATERGRAVE TEE
28580 SLIPKNOT GRAPHIC GOAT T-Shirts
28717 SUICIDE SILENCE SKULL KINGDOM
28718 SUICIDE SILENCE PURPLE TIME STEALER
35287 SLIPKNOT Fashion Tee Logo Star
35290 SLIPKNOT CREATURES
35292 SLIPKNOT PAUL GRAY
35293 SLIPKNOT RUSTY FACE
35294 SLIPKNOT SHATTERED
35501 SLIPKNOT New Masks T-Shirt
35502 SLIPKNOT Blocks T-Shirt
35503 SLIPKNOT Dead Effect T-Shirt
35504 SLIPKNOT Skeptic T-Shirt
35506 SLIPKNOT Skull Group T-Shirt
35507 SLIPKNOT Logo T-Shirt
35508 SLIPKNOT The Wheel T-Shirt
35509 SLIPKNOT Goat Star Logo T-Shirt
35510 SLIPKNOT Giant Star T-Shirt
35641 MARILYN MANSON SWEET DREAMS T-SHIRTS
35647 MARILYN MANSON MIRRORED DRESS T-SHIRTS
35648 MARILYN MANSON Mirrored T-Shirts
35650 MARILYN MANSON ANTICHRIST T-SHIRTS
35651 MARILYN MANSON Bigger than Satan Tee Dress
36540 MARILYN MANSON -Striped Face Jumbo Print-2012 Tour Backprint-
36674 KORN (RED LOGO) Beanie
36678 MARILYN MANSON VILLAIN 2012
36697 SLIPKNOT THE GRAY CHAPTER
51190 SLIPKNOT UNISEX FINGERLESS GLOVES: LOGO
70716 Survive Said The Prophet OMEN TEE
70717 Survive Said The Prophet MUSEUM TEE
70719 Survive Said The Prophet CIRCLE BUCKET HAT BLACK
70720 Survive Said The Prophet CIRCLE BUCKET HAT POWDER
70722 Survive Said The Prophet UNIVERSE BUCKET HAT
14117 KORN MOSAIC TEE
36780 SLIPKNOT Admat 2015 T-shirt
36843 KORN Shield T-shirt
36844 KORN Zombie Slam 2010 Tour T-shirt
36863 SUICIDE SILENCE Grim Reaper Candle Black T-shirt
36994 SLIPKNOT -Broken Glass-Black t-shirt
36995 SLIPKNOT Knotfest-Brain Ripper-Black t-shirt
36997 SLIPKNOT .5. THE GRAY CHAPTER T-SHIRT
36998 SLIPKNOT PENTAGRAM TEE
36861 SLIPKNOT Smashed-2015 World Tour-Black t-shirt
52941 Survive Said The Prophet VERTICAL LOGO TEE
52942 Survive Said The Prophet MIA TOUR TEE
52948 Survive Said The Prophet UNBALANCE TEE LIGHT BLUE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
52951 Survive Said The Prophet UNBALANCE TEE YELLOW