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-28 01:29:21')
AND pc.price02 > 2727
AND price02 <= 4545
AND pc.classcategory_id1 IN( 13,35,44)
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 0, 120
64930 MISHKA (ミシカ) M21100064 T-SHIRT BLACK
63078 MISHKA (ミシカ) M21100025 T-SHIRT WHITE
61759 MISHKA (ミシカ) M21100407 HOODIE
60726 MISHKA M61000452 HOODIE
60729 MISHKA M61000841 PANTS
60664 MISHKAM M61000413 CREW
60291 MISHKA M61000907W PANT
60166 MISHKA X DENNIS THE MENACE TROUBLE MAKER SHORTS
60167 MISHKA X DENNIS THE MENACE TROUBLE MAKER HOODIE RED
58126 MISHKA M21000006 T-Shirt Beige
51494 MISHKA MSS201002W31 SKIRT INDIGO
64928 MISHKA (ミシカ) M21100061 T-SHIRT BLACK
60293 MISHKA M61000007 T-SHIRT PURPLE
60271 MISHKA M61000053 T-SHIRT BLACK
60272 MISHKA M61000053 T-SHIRT BLUE
60270 MISHKA M61000056 T-SHIRT WHITE
60269 MISHKA M61000056 T-SHIRT PURPLE
58820 MISHKA(ミシカ) M21000012 T-SHIRTS WHITE
58575 MISHKA(ミシカ) M21000067 T-Shirt GREEN
58576 MISHKA(ミシカ) M21000067 T-Shirt PURPLE
58130 MISHKA M21000007 T-Shirt Green
57359 MISHKA M21000013 T-Shirt WHITE
57358 MISHKA M21000013 T-Shirt BLACK
58626 MISHKA OPTIC KEEP WATCH TEE BLACK
57365 MISHKA M21000001 L/S T-Shirt WHITE
56877 MISHKA(ミシカ) MAW200470 HOODIE ORANGE
55912 MISHKA MAW200004 T-SHIRTS BEIGE
55900 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS BLACK
55902 MISHKA x Johnny Ryan WILLY WASHUMS S/S T-SHIRTS
54198 MISHKA MSS200029M80 T-SHIRTS WHITE
54196 MISHKA MSS200033F80 T-SHIRTS WHITE
54450 MISHKA(ミシカ) MSS200839 SHORTS
6317 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK BLACK
7289 MISHKA (ミシカ) KEEP WATCH TANK TOP WHITE
8921 MISHKA (ミシカ) OVERSIZE ETD BADGE T-SHIRT ATHLETIC HEATHER
8923 MISHKA (ミシカ) OVERSIZE ETD BADGE T-SHIRT BLACK
10815 MISHKA (ミシカ) DEATH DEALER T-SHIRT GREY LAVA TIE DYE
10822 MISHKA (ミシカ) CYCO PUSHER TANK TOP TIE-DYE
10832 MISHKA (ミシカ) KEEP WATCH TANK RED
12192 MISHKA (ミシカ) SNAKE BITE BOA TANK TOP BOA
12195 MISHKA (ミシカ) BEAST OF THE EAST TANK TOP WHITE
12204 MISHKA (ミシカ) MR. NICE GUY II TANK TOP STRAWBERRY
12207 MISHKA (ミシカ) KEEP WATCH TANK TOP BLACK
12208 MISHKA (ミシカ) KEEP WATCH TANK TOP WHITE
12264 MISHKA (ミシカ) SONS OF NIHILISM T-SHIRT RED TIE DYE
12282 MISHKA (ミシカ) PERMANEBT VACATION T-SHIRT TEAL TIE DYE
12321 MISHKA (ミシカ) OVERSPRAY KEEP WATCH T-SHIRT NAVY TIE DYE
12322 MISHKA (ミシカ) OVERSPRAY KEEP WATCH T-SHIRT PURPLE
12323 MISHKA (ミシカ) OVERSPRAY KEEP WATCH T-SHIRT BLACK
13309 MISHKA (ミシカ) DEATH RITUAL 78 T-SHIRT BLACK
13310 MISHKA (ミシカ) PARALYZED T-SHIRT BLACK
13497 MISHKA (ミシカ) KIRBY KEEP WATCH CAMO T-SHIRT CAMO
13500 MISHKA (ミシカ) DEATH ADDER T-SHIRT BLACK
13501 MISHKA (ミシカ) DEATH ADDER T-SHIRT TEAL
13502 MISHKA (ミシカ) DEATH ADDER T-SHIRT PURPLE
13771 MISHKA (ミシカ) ALTITUDE KEEP WATCH T-SHIRT BLK
13772 MISHKA (ミシカ) ALTITUDE KEEP WATCH T-SHIRT RED
14842 MISHKA (ミシカ) AUTOPSY DEATH LONGSLEEVE T-SHIRT
14903 MISHKA (ミシカ) AUTOPSY SKULL T-SHIRT WHITE
14906 MISHKA (ミシカ) SOCIETY OF THE SNAKE REDUX CAMO T-SHIRT
14907 MISHKA (ミシカ) LAMOUR UNDERTOW T-SHIRTMarble Lime Tie Dye
14908 MISHKA (ミシカ) RITUAL COLUMN LONGSLEEVE T-SHIRT
16364 MISHKA (ミシカ) CRUSHED/KEEP WATCH REVERSIBLE BUCKET
17417 MISHKA (ミシカ) BALANCED KEEP WATCH T-SHIRT RED
17527 MISHKA (ミシカ) ULTRA-SIZED DEATH ADDER T-SHIRT
18840 MISHKA (ミシカ) BLIND SPOT BASKETBALL JERSEY
18849 MISHKA (ミシカ) CYCO SIGHT TIE DYE TANK TOP
19802 MISHKA (ミシカ) MAINFRAME BEAR MOP T-SHIRT
19803 MISHKA (ミシカ) GLITCH IN THE DOMINATRIX T-SHIRT
19804 MISHKA (ミシカ) KEEP WATCH (GID) T-SHIRT Black Spiral TD
19809 MISHKA (ミシカ) RADIOACTIVE BLOCK T-SHIRT
19811 MISHKA (ミシカ) STONEY BALONEY TIE DYE T-SHIRT
20314 MISHKA (ミシカ) ATOMIC KEEP WATCH TIE-DYE T-SHIRT INFERNO
20326 MISHKA (ミシカ) KEEP WATCH TIE-DYE T-SHIRT ORANGE
20347 MISHKA (ミシカ) KEEP WATCH L/S SHIRT (BLACK)
20448 MISHKA (ミシカ) ANDREI BOUZIKOV KEEP WATCH L/S SHIRT BLK
20452 MISHKA (ミシカ) ANDREI BOUZIKOV: KEEP WATCH TIE-DYE T-SHIRT
20496 MISHKA (ミシカ) CYCO MANIA TIE-DYE T-SHIRT RED SPIRAL
20611 MISHKA (ミシカ) LAMOUR SUPREME: DEATH ADDER TIE-DYE T-SHIRT
21274 MISHKA (ミシカ) NEW PANIC REVERSIBLE BUCKET HAT Green/Whiti
21726 MISHKA (ミシカ) SPENCER NUZZI: LUCK'S RUN OUT L/S SHIRT
21802 MISHKA (ミシカ) Lamour’s 2 Headed Monster T-Shirt BLK
21804 MISHKA (ミシカ) Gazin’s Oscar the Grouch T-Shirt WHT
21805 MISHKA (ミシカ) Gazin’s Oscar the Grouch T-Shirt DIEDYE
21809 MISHKA (ミシカ) Yard Bird Longsleeve
21836 MISHKA (ミシカ) MIGHTY HEALTHY: SCAVENGERS T-SHIRT
21838 MISHKA (ミシカ) MIGHTY HEALTHY: KEEP WATCH T-SHIRT
21839 MISHKA (ミシカ) MIGHTY HEALTHY: COVER T-SHIRT
21840 MISHKA (ミシカ) MIGHTY HEALTHY: WARHEAD RAGLAN
21911 MISHKA (ミシカ) MIGHTY HEALTHY: WARHEAD T-SHIRT
21913 MISHKA (ミシカ) STATIC-AGE LONGSLEEVE TEE
21915 MISHKA (ミシカ) DEATH ADDER LONGSLEEVE TEE
21917 MISHKA (ミシカ) AWAY KEEP WATCH LONGSLEEVE TEE BLK
21918 MISHKA (ミシカ) AWAY KEEP WATCH LONGSLEEVE TEE WHT
21927 MISHKA (ミシカ) CYRILLIC LEGACY LONGSLEEVE TEE
22049 MISHKA (ミシカ) CYCO MUTATION TEE BLACK
22050 MISHKA (ミシカ) CYCO MUTATION TEE WHITE
23443 MISHKA (ミシカ) NATION OF MILLIONS L/S TEE Gold
23444 MISHKA (ミシカ) LAMOUR BOARD WALK L/S TEE Black
23445 MISHKA (ミシカ) LAMOUR BOARD WALK L/S TEE White
23867 MISHKA (ミシカ) SICK SAD KEEP WATCH L/S TIE DYE TEE Lime/Kelly Tie Dye
23873 MISHKA (ミシカ) HERITAGE KEEP WATCH L/S TEE WHITE
23884 MISHKA (ミシカ) DEMO DERBY KEEP WATCH TEE BLACK
24192 MISHKA (ミシカ) TALLBOY KEEP WATCH TIE DYE TEE Lime Crinkle Tie Dye
24194 MISHKA (ミシカ) METAL DEATH ADDER L/S TEE White
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
24356 MISHKA (ミシカ) LAMOUR DAYTONA 1978 TEE
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
24980 MISHKA (ミシカ) CHOCOMOO PATTERNED ALL OVER BUCKET HAT
25936 MISHKA (ミシカ) LAMOUR KEEP WATCH T-SHIRT