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-30 22:15:43')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 664)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 180
64304 RIPNDIP (リップンディップ) Summer Break Sticker Pack
60592 RIPNDIP Lord Nermal Pocket Tee Mist Grape
60593 RIPNDIP Lord Nermal Pocket Tee Slate
60598 RIPNDIP Far Far Away Tee (Black/Pink/Blue Spiral Dye)
60603 RIPNDIP Lord Nermal Pocket Long Sleeve (Light Lime)
60605 RIPNDIP Lord Nermal Pocket Long Sleeve (Dusty Rose)
52971 RIPNDIP Lord Nermal Low Socks (Black)
52972 RIPNDIP Lord Nermal Low Socks (White)
60602 RIPNDIP Logo Embroidered Tee (Natural Speckle)
41041 RIPNDIP NERM LINE CAMO SOCKS BLACK
47345 RIPNDIP Lord Nermal Socks (Light Orange)
47346 RIPNDIP Lord Nermal Socks (Baby Blue)
47347 RIPNDIP Lord Nermal Socks (Safety Green)
47348 RIPNDIP Lord Nermal Socks (Mint)
47349 RIPNDIP Lord Nermal Socks (Royal)
47350 RIPNDIP Lord Nermal Socks (Watermelon)
52964 RIPNDIP Lord Nermal Socks (Baby Blue Tie Dye)
52965 RIPNDIP Lord Nermal Socks (Black Tie Dye)
52966 RIPNDIP Pill Socks (Black Tie Dye)
52967 RIPNDIP Peek A Nermal Socks (Mint)
52968 RIPNDIP Lord Nermal Socks (Orange Speckle)
52969 RIPNDIP Lord Nermal Socks (Navy Speckle)
52970 RIPNDIP Lord Nermal Socks (Gray Speckle)
60642 RIPNDIP Lord Nermal Mid Socks (White)
60643 RIPNDIP Welcome To Heck Socks (Electric Blue)
60644 RIPNDIP Lord Nermal Mid Socks (Black)
64294 RIPNDIP (リップンディップ) Lord Nermal Socks (Cornflower)
64295 RIPNDIP (リップンディップ) Lord Nermal Socks (Pine)
64296 RIPNDIP (リップンディップ) Checked Socks (Olive)
64297 RIPNDIP (リップンディップ) Lord Nermal Socks (White)
64298 RIPNDIP (リップンディップ) Lord Nermal Socks (Black)
65449 RIPNDIP (リップンディップ) Jerm Face Mid Socks (Black)
65450 RIPNDIP (リップンディップ) Nerm Face Mid Socks (White)
65451 RIPNDIP (リップンディップ) Hell Of A Drug Mid Socks (Black)
65452 RIPNDIP (リップンディップ) Bye Bye Socks (Black)
65455 RIPNDIP (リップンディップ) Fuckin Fuck Socks (Black)
65456 RIPNDIP (リップンディップ) Lord Nermal Socks (Cobalt Blue)
66876 RIPNDIP (リップンディップ) Peeking Nermal Socks Pine / Slate
66877 RIPNDIP (リップンディップ) Jolly Holiday Socks Navy
66878 RIPNDIP (リップンディップ) F U Mid Socks Light Pine
66879 RIPNDIP (リップンディップ) Lord Nermal Mid Socks Violet
66880 RIPNDIP (リップンディップ) Shroom Diet Lanyard Pistachio
66881 RIPNDIP (リップンディップ) Taste The Rainbow Lanyard Lavender
66882 RIPNDIP (リップンディップ) Fuckin Fuck Lanyard Black
48347 RIPNDIP Summer 2019 Sticker Pack
43234 RIPNDIP Fall 18 Sticker Pack
60596 RIPNDIP Not Today Tee White
52712 RIPNDIP Catch Em All Lanyard (Multi)
60636 RIPNDIP Lord Nermal Beanie (Pink Tie Dye)
67895 RIPNDIP (リップンディップ) Lord Nermal Socks (Light Slate)
67896 RIPNDIP (リップンディップ) Lord Nermal Mid Socks (Olive)
64265 RIPNDIP (リップンディップ) Summer Splash Tee (Black)
64259 RIPNDIP (リップンディップ) Beach Boys Tee (Purple Mineral Wash)
68540 RIPNDIP (リップンディップ) Nermal Loves Socks WHITE
68541 RIPNDIP (リップンディップ) Nermal Loves Socks BLACK
69580 RIPNDIP (リップンディップ) LORD NERMAL MID SOCKS DUSTY LAVENDER
69581 RIPNDIP (リップンディップ) NERMAL LOVES MID SOCKS (BLACK)
69582 RIPNDIP (リップンディップ) NERMAL LOVES SOCKS (CHARCOAL)
69583 RIPNDIP (リップンディップ) PEEKING NERMAL SOCKS (PURPLE & GOLD)
69584 RIPNDIP (リップンディップ) MONEYBAG SOCKS (OLIVE)
69585 RIPNDIP (リップンディップ) SUSHI NERM SOCKS
70615 RIPNDIP (リップンディップ)PEEKING NERMAL SOCKS (WHITE/LILAC)
70616 RIPNDIP (リップンディップ)LORD NERMAL SOCKS (WARM GRAY)
70617 RIPNDIP (リップンディップ)LORD NERMAL SOCKS (BLACK HEATHER)
71299 RIPNDIP (リップンディップ) ILY FUCKIN FUCK SOCKS
71300 RIPNDIP (リップンディップ) PEEKING NERMAL SOCKS (WHITE)
71301 RIPNDIP (リップンディップ) LORD NERMAL SOCKS (CHARCOAL)
71302 RIPNDIP (リップンディップ) LOVE YOU MID SOCKS (WHITE)
47356 RIPNDIP Nerm Camo Lanyard (Smoke Camo)
47357 RIPNDIP Oversize Camo Lanyard (Multi)
48323 RIPNDIP Nerm Camo Lanyard (Choc Chip Camo)
41607 RIPNDIP OG Lord Nermal Tote Bag (Natural Canvas)
44247 RIPNDIP New York Tote Bag (Natural Canvas)
47351 RIPNDIP My Little Nerm Tote Bag (Natural Canvas)
60641 RIPNDIP Scribble Face Mask (Green)
47652 RIPNDIP Black Out Nylon Shorts (Black Out Camo)
60599 RIPNDIP Not Today Embroidered Crewneck (Light Blue)
65453 RIPNDIP(リップッディップ) Peek A Nermal Boxers (Cobalt Blue)
65454 RIPNDIP(リップッディップ) Peek A Nermal Boxers (Pine)
64255 RIPNDIP (リップンディップ) Nikola Embroidered Tee (Black/Blue)
64302 RIPNDIP (リップンディップ) Lord Jermal Leaf Camo Slides (3M Iridescent)
64303 RIPNDIP (リップンディップ) Lord Nermal Slides (Iridescent)
52958 RIPNDIP Peek A Nermal Sweat Shorts (Multi Tie Dye)
52959 RIPNDIP Rock N Nermal Sweat Shorts (Multi)
60640 RIPNDIP Lord Nermal Plush Backpack (White)
50699 RIPNDIP NERM CAMO SWEATSHORTS
65434 RIPNDIP (リップンディップ) Dark Twisted Fantasy Short Sleeve Tee (Black/White)
60608 RIPNDIP Beverly Nylon Cargo Shorts (Blue)
50706 RIPNDIP ICE CREAM SURFER FRISBEE
60647 RIPNDIP Lord Jermal Pencil Pouch
60589 RIPNDIP Stellar Hoodie (Purple/Blue Spiral Dye)
60595 RIPNDIP Peeking Nermal Embroidered Hoodie (Purple Mineral Wash)
64291 RIPNDIP (リップンディップ) Praying Hands Dad Hat (Black)
64300 RIPNDIP (リップンディップ) Nikola Fanny Pack (Blue)
47650 RIPNDIP RIPNTAIL Hoodie (Black)
64285 RIPNDIP (リップンディップ) Wilshire Sweatshorts (Blue Stripe Dye)
64308 RIPNDIP (リップンディップ) Lord Nermal Ribbed Beanie (Black)
65445 RIPNDIP (リップンディップ) Lord Nermal Patch Beanie (Navy Lightning Wash)
65446 RIPNDIP (リップンディップ) Peeking Nermal Beanie 3M Reflective (Black)
65448 RIPNDIP (リップンディップ) LORD NERMAL BEANIE 3M REFLECTIVE Beanie (MULTI)
48346 RIPNDIP Paddle Up Paddle Ball Set
66870 RIPNDIP (リップンディップ) Lord Nermal Beanie Black / Mint Tie Dye
65443 RIPNDIP (リップンディップ) Lord Nermal Pom Beanie (Black/Sage/Pine)
60637 RIPNDIP Lord Nermal Beanie (Black / Rainbow Tie Dye)
43230 RIPNDIP Lord Nermal Ribbed Beanie (Charcoal)
43231 RIPNDIP Lord Nermal Ribbed Beanie (Forest)
43232 RIPNDIP Lord Nermal Ribbed Beanie (Navy)
60594 RIPNDIP Lord Nermal Pocket Tee Cotta Orange
64257 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Natural)
64258 RIPNDIP (リップンディップ) Nerms Diner Tee (Natural)
64261 RIPNDIP (リップンディップ) Homegrown Treats Tee (Black)
64267 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Gray)
64260 RIPNDIP (リップンディップ) Lifes A Beach Tee (Light Blue Mineral Wash)
64262 RIPNDIP (リップンディップ) Nerm Cruiser Tee (Black Mineral Wash)
64263 RIPNDIP (リップンディップ) Nerm Jam (Black Mineral Wash)
64264 RIPNDIP (リップンディップ) Abduction Tee (Black Mineral Wash)
41034 RIPNDIP LORD NERMAL POCKET TEE BLACK
41035 RIPNDIP LORD NERMAL POCKET TEE AQUA MINERAL WASH
41036 RIPNDIP LORD NERMAL POCKET TEE WINE
41086 RIPNDIP LORD NERMAL POCKET TEE GRAY
41614 RIPNDIP Dead Rose Knit Sweater (Black)
41618 RIPNDIP Inferno Tee (Olive)
47335 RIPNDIP Flat Tee (Gray Heather)
47336 RIPNDIP Flat Tee (Black)
47337 RIPNDIP My Little Nerm Tee (White)
47338 RIPNDIP Herb Eater Tee (Black)
47339 RIPNDIP Break Yo Self Pocket Tee (Black)
47653 RIPNDIP My Little Nerm Tee (Pink)
52708 RIPNDIP Catch Em All Tee (Yellow)
52709 RIPNDIP Nermio Tee (Black)
52710 RIPNDIP Lights Out Tee (Black)
65429 RIPNDIP (リップンディップ) High On Life Hoodie (Black)
69587 RIPNDIP (リップンディップ) PEEKING NERMAL BEANIE (STORM BLUE)
69588 RIPNDIP (リップンディップ) LORD NERMAL WAFFLE KNIT BEANIE (CHARCOAL)
70613 RIPNDIP (リップンディップ) PEEKING NERMAL BEANIE (ALPINE GREEN)
70614 RIPNDIP (リップンディップ) LORD NERMAL SPLIT BEANIE (NAVY/SLATE)
52961 RIPNDIP Nermhog Tee (Black)
48334 RIPNDIP Ass Assasin Tee (Vintage White)
48335 RIPNDIP Heavinly Bodies Tee (Black)
48336 RIPNDIP Heavinly Bodies Tee (Light Blue)
48337 RIPNDIP Skate Nerm Tee (Black)
48338 RIPNDIP Skate Nerm Tee (Safety Green)
48339 RIPNDIP Split Tee (Lavender)
48340 RIPNDIP The Whole Gang Tee (Black)
48341 RIPNDIP Illusion Reflective Tee (Black)
48344 RIPNDIP Lord Jermal Pocket Tee (Wine)
48345 RIPNDIP Lord Jermal Pocket Tee (Gray)
50707 RIPNDIP ALARM CLOCK
41037 RIPNDIP LORD NERMAL POCKET TEE WHITE
64266 RIPNDIP (リップンディップ) Lord Nermal Pocket tee (Black Mineral Wash)
64306 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Black)
64327 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (White)
66860 RIPNDIP (リップンディップ) Already Won Tee Charcoal
66861 RIPNDIP (リップンディップ) Caterpillar Garden Tee Black
41032 RIPNDIP NERMCASSO TEE PINK
41033 RIPNDIP NERMCASSO TEE YELLOW
41038 RIPNDIP HANG IN THERE POCKET TEE ASH
41039 RIPNDIP HANG IN THERE POCKET TEE HUNTER GREEN
41040 RIPNDIP CAT NIP TEE NAVY BLUE
42908 RIPNDIP Falling For Nermal Pocket Tee White
42909 RIPNDIP Hang In There Nermal Pocket Tee White
42910 RIPNDIP Hang In There Nermal Pocket Tee Black
44891 RIPNDIP Poison Tee (White)
44892 RIPNDIP Pill Tee (Black)
44893 RIPNDIP Romantic Nerm Tee (Black)
60600 RIPNDIP Day Tripper Long Sleeve (Black)
60601 RIPNDIP Lord Nermal Pocket Long Sleeve (Black)
60606 RIPNDIP Lord Nermal Pocket Long Sleeve (Cherry Red)
41609 RIPNDIP Everything Will Be Ok Nylon Camper (Salmon)
41610 RIPNDIP Peeking Nylon Camper (Navy / Red / White)
41611 RIPNDIP Nerm 3M Line Camo Nylon Camper (Black)
48322 RIPNDIP Lord Nermal 6 Panel Pocket Hat (Black)
60635 RIPNDIP Not Today Strapback (Light Blue Tie Dye)
64289 RIPNDIP (リップンディップ) Shroom Mania Strapback (Bone)
64290 RIPNDIP (リップンディップ) Summer Revenge 6 Panel (Black)
64362 RIPNDIP (リップンディップ) Lord Nermal 6 Panel Pocket Hat (Black)
65436 RIPNDIP (リップンディップ) High On Life Tee (Black Mineral Wash)
65437 RIPNDIP (リップンディップ) Super High Tee (Black Mineral Wash)
65438 RIPNDIP (リップンディップ) Power Tee (Black Mineral Wash)
65439 RIPNDIP (リップンディップ) The Unknown Tee (Purple Mineral Wash)