SELECT SQL_CALC_FOUND_ROWS 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-19 22:36:02')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 240)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 840, 120
24197 MISHKA (ミシカ) LAMOUR LIVING DEATH ADDERS TIE DYE TEE Black Crinkle Tie Dye
24198 MISHKA (ミシカ) LAMOUR KILL WITH POWER TIE DYE TEE Purple Sphere Tie Dy
24199 MISHKA (ミシカ) CYRILLIC SCRIPT SNAPBACK
24200 MISHKA (ミシカ) HERITAGE KEEP WATCH PATTERN SOCKS (Blac
24356 MISHKA (ミシカ) LAMOUR DAYTONA 1978 TEE
24801 MISHKA (ミシカ) REFLECTIVE KEEP WATCH SNAPBACK
24968 MISHKA (ミシカ) CHOCOMOO LOGO TEE White
24969 MISHKA (ミシカ) CHOCOMOO LOGO TEE Black
24970 MISHKA (ミシカ) MASK KEEP WATCH TEE White
24971 MISHKA (ミシカ) MASK KEEP WATCH TEE Black
24972 MISHKA (ミシカ) LIGHT BULB TEE White
24973 MISHKA (ミシカ) LIGHT BULB TEE Black
24974 MISHKA (ミシカ) SECRET DATING TEE White
24975 MISHKA (ミシカ) SECRET DATING TEE Black
24977 MISHKA (ミシカ) LIGHT BULB EYEBALL L/S TEE White
24978 MISHKA (ミシカ) LIGHT BULB EYEBALL L/S TEE Black
24979 MISHKA (ミシカ) LIGHT BULB EYEBALL GOLF CAP
24980 MISHKA (ミシカ) CHOCOMOO PATTERNED ALL OVER BUCKET HAT
24981 MISHKA (ミシカ) x Chocomoo Sticker
24982 MISHKA (ミシカ) MASK KEEP WATCH SNAPBACK
25190 MISHKA (ミシカ) BASEBALL SHIRT DENIM SMOKEY KEEP WATCH
25216 MISHKA (ミシカ) KEEP WATCH TOY
25315 MISHKA (ミシカ) GALAXY KEEP WATCH TEE WHITE
25316 MISHKA (ミシカ) GALAXY KEEP WATCH TEE BLACK
25317 MISHKA (ミシカ) LAMOUR RING OF HELL KW TEE WHITE
25318 MISHKA (ミシカ) LAMOUR RING OF HELL KW TEE BLACK
25319 MISHKA (ミシカ) CYRILLIC KEEP WATCH TEE WHITE
25320 MISHKA (ミシカ) CYRILLIC KEEP WATCH TEE BLACK
25321 MISHKA (ミシカ) CLASSIC KEEP WATCH TEE WHITE
25322 MISHKA (ミシカ) CLASSIC KEEP WATCH TEE BLACK
25323 MISHKA (ミシカ) COOKIE KEEP WATCH TEE WHITE
25324 MISHKA (ミシカ) COOKIE KEEP WATCH TEE BLACK
25325 MISHKA (ミシカ) SMILEY KEEP WATCH TEE WHITE
25326 MISHKA (ミシカ) SMILEY KEEP WATCH TEE BLACK
25327 MISHKA (ミシカ) CAMO KEEP WATCH TEE WHITE
25328 MISHKA (ミシカ) CAMO KEEP WATCH TEE BLACK
25936 MISHKA (ミシカ) LAMOUR KEEP WATCH T-SHIRT
25937 MISHKA (ミシカ) KEEP WATCH PATTERN DUNNY T-SHIRT
26551 MISHKA (ミシカ) EXPLODING KEEP WATCH NEW ERA 5950
26553 MISHKA (ミシカ) TONAL KEEP WATCH TEE Black
26554 MISHKA (ミシカ) TONAL KEEP WATCH TEE White
26555 MISHKA (ミシカ) TRASH POCKET TEE White
26556 MISHKA (ミシカ) CARTOON ADDER TEE
26557 MISHKA (ミシカ) DEMONS TEE Black
26558 MISHKA (ミシカ) DEMONS TEE White
26559 MISHKA (ミシカ) TONAL NEIGHBORHHOOD SNIPER TEE Black
26560 MISHKA (ミシカ) TONAL NEIGHBORHHOOD SNIPER TEE White
26561 MISHKA (ミシカ) YARD DOG CARGO SHORTS
26562 MISHKA (ミシカ) WOLF SPIDER SHORTS
26563 MISHKA (ミシカ) DETENTION SHORTS
26564 MISHKA (ミシカ) YARD DOG BUTTON UP
26565 MISHKA x FAMOUS STARS AND STRAPS ALL SEEING SNAPBACK
26566 MISHKA (ミシカ) DAMAGED KEEP WATCH TANK
26567 MISHKA x FAMOUS STARS AND STRAPS SNAPBACK WHITE
26568 MISHKA (ミシカ) NEIGHBORHOOD KEEP WATCH SNAPBACK
26569 MISHKA (ミシカ) CREEP SNAPBACK
26570 MISHKA (ミシカ) LAMOUR KEEP WATCH SNAPBACK
26571 MISHKA (ミシカ) DEATH ADDER SPORT SNAPBACK White
26572 MISHKA (ミシカ) DEATH ADDER SPORT SNAPBACK Black
26573 MISHKA (ミシカ) KEEP WATCH CAP
26574 MISHKA (ミシカ) WE GET OURS SNAPBACK
26575 MISHKA (ミシカ) ERMSY KEEP WATCH CAP
26576 MISHKA (ミシカ) DAMAGED KEEP WATCH SNAPBACK Black
26577 MISHKA (ミシカ) DAMAGED KEEP WATCH SNAPBACK White
26578 MISHKA (ミシカ) KEEP WATCH SNAPBACK
26579 MISHKA (ミシカ) CARTOON ADDER SNAPBACK
26580 MISHKA (ミシカ) MONOCHROME KEEP WATCH SNAPBACK Royal
27450 MISHKA (ミシカ) LAMOUR KEEP WATCH WAVE TIE DYE TEE Lime Tiger Stripe Tie Dye
27451 MISHKA (ミシカ) LAMOUR KEEP WATCH WAVE TIE DYE TEE Pink Purple Horizontal Wave
27453 MISHKA (ミシカ) LAMOUR KEEP WATCH WAVE TIE DYE TEE Turquoise Crinkle Tie Dye
27456 MISHKA (ミシカ) ATTITUDE ADJUSTER TEE
27459 MISHKA (ミシカ) EXPLODING KEEP WATCH TEE
27462 MISHKA (ミシカ) EXPLODING KEEP WATCH TANK Black
27464 MISHKA (ミシカ) EXPLODING KEEP WATCH TANK White
27467 MISHKA (ミシカ) BLAZER KEEP WATCH TEE
27468 MISHKA (ミシカ) DAMAGED KEEP WATCH TEE Black
27469 MISHKA (ミシカ) DAMAGED KEEP WATCH TEE White
27470 MISHKA (ミシカ) DAMAGED KEEP WATCH TEE Red
27471 MISHKA (ミシカ) LAMOUR KEEP WATCH II TEE
27472 MISHKA (ミシカ) LAMOUR DEATH ADDER TEE
27473 MISHKA (ミシカ) CLASSIC KEEP WATCH RINGER TEE
27475 MISHKA (ミシカ) WE GET OURS TEE
27477 MISHKA (ミシカ) ERMSY KEEP WATCH TEE
27480 MISHKA (ミシカ) MONOCHROME KEEP WATCH TEE
27483 MISHKA (ミシカ) JV KEEP WATCH BASKETBALL JERSEY Black
27487 MISHKA (ミシカ) DAMAGED KEEP WATCH SHORTS
27488 MISHKA (ミシカ) WE GET OURS BASEBALL JERSEY
27489 MISHKA (ミシカ) KEEP WATCH BASEBALL JERSEY
27490 MISHKA (ミシカ) LAMOUR KEEP WATCH TIE DYE SNAPBACK Pink
27491 MISHKA (ミシカ) KEEP WATCH TIE DYE SNAPBACK Seafoam
27492 MISHKA (ミシカ) ERMSY KEEP WATCH TIE DYE TANK
27497 MISHKA (ミシカ) KEEP WATCH RINGER TEE
27834 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING F TEE BLK
27835 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING F TEE WHT
27836 FAMOUS STARS AND STRAPS x MISHKA MERCY TEE BLK
27837 FAMOUS STARS AND STRAPS x MISHKA MERCY TEE WHT
27838 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING HOODIE WHT
27839 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING HOODIE GRY
28093 MISHKA GALAXY KEEP WATCH STICKER
28094 MISHKA RING OF HELL KEEP WATCH STICKER
28095 MISHKA RETRO KEEP WATCH STICKER
28096 MISHKA CLASSIC KEEP WATCH STICKER
28097 MISHKA COOKIE KEEP WATCH STICKER
28098 MISHKA SMILEY KEEP WATCH STICKER
28099 MISHKA CAMO KEEP WATCH STICKER
28185 MISHKA (ミシカ) SOFT CREAM TEE BLACK
28186 MISHKA (ミシカ) WATERMALON TEE BLACK
28187 MISHKA (ミシカ) ICE TEE BLACK
28231 MISHKA(ミシカ) UNIVERSAL GRAND ORDER RXR WORKMAN PULLOVER
28505 MISHKA(ミシカ) ALL OVER BACK PACK
28507 MISHKA(ミシカ) KEEP WATCH BACK PACK
28556 MISHKA (ミシカ) MAW163207F CAP BLACK
28557 MISHKA (ミシカ) MAW163212F CAP GALAXY BLACK
28558 MISHKA (ミシカ) MAW160501M JKT BLACK
28559 MISHKA (ミシカ) MAW160503M JKT WHITE
28560 MISHKA (ミシカ) MAW160003M TEE WHITE
28561 MISHKA (ミシカ) MAW160004M L/S BLACK
28562 MISHKA (ミシカ) MAW160004M L/S WHITE
28563 MISHKA (ミシカ) MAW160503M JKT BLACK
28564 MISHKA (ミシカ) MAW160006M TEE WHITE