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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-01 18:10:22')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.classcategory_id1 IN( 11)
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
69290 MISHKA (ミシカ) M61200052 Embroidery Tee Ivory
69291 MISHKA (ミシカ) M61200052 Embroidery Black
68220 MISHKA (ミシカ) CROWN TEDDY BEAR TEE M21200014 WHITE
65665 MISHKA (ミシカ) M61100053 MONOGRAM“MOP”Tee
65672 MISHKA (ミシカ) M61100008 "KEEP WATCH"Tee BLACK
65673 MISHKA (ミシカ) M61100001 “MOP”GRAPHIC Tee WHITE
65674 MISHKA (ミシカ) M61100001 “MOP”GRAPHIC Tee BLACK
65675 MISHKA (ミシカ) M61100003 WHITE“MOP”Tee
64925 MISHKA (ミシカ) M21100062 T-SHIRT OFF WHITE
64927 MISHKA (ミシカ) M21100061 T-SHIRT WHITE
63098 MISHKA (ミシカ) M21100009 T-SHIRT YELLOW
68059 MISHKA (ミシカ) CREAMY TEE (A.BLUE/MIJT-01BLU)
68062 MISHKA (ミシカ) CREAMY TEE (T.PINK/MIJT-01PNK)
68058 MISHKA (ミシカ) CREAMY TEE (BLACK/MIJT-01BLK)
68057 MISHKA (ミシカ) INFINITE PAIN TEE (WHITE/MIDT-01WHT)
68056 MISHKA (ミシカ) INFINITE PAIN TEE (BLACK/MIDT-01BLK)
64926 MISHKA (ミシカ) M21100062 T-SHIRT BLACK
61784 MISHKA (ミシカ) M21100032 T-SHIRT L.GREEN
61766 MISHKA (ミシカ) M21100001 T-SHIRT L.GREEN
60173 MISHKA X DENNIS THE MENACE DENNIS TEE BLACK
58745 MISHKA NEW WORLD ORDER TEE BLACK
58819 MISHKA(ミシカ) M21000012 T-SHIRTS BLACK
58824 MISHKA(ミシカ) M21000021 T-SHIRTS
58574 MISHKA(ミシカ) M21000029 T-Shirt
58131 MISHKA M21000007 T-Shirt Yellow
58133 MISHKA M21000066 T-Shirt Yellow
58127 MISHKA M21000011 T-Shirt Black
57360 MISHKA M21000013 T-Shirt GREEN
58125 MISHKA M21000006 T-Shirt Black
58744 MISHKA NEW WORLD ORDER TEE WHITE
58746 MISHKA NEW WORLD ORDER TEE BLUE
58625 MISHKA OPTIC KEEP WATCH TEE GREEN
57363 MISHKA M21000059 T-Shirt ORANGE
61764 MISHKA (ミシカ) M21100011 T-SHIRT
63077 MISHKA (ミシカ) M21100039 T-SHIRT BLACK
64929 MISHKA (ミシカ) M21100064 T-SHIRT WHITE
63099 MISHKA (ミシカ) M21100009 T-SHIRT PURPLE
63100 MISHKA (ミシカ) M21100009 T-SHIRT BLACK
63079 MISHKA (ミシカ) M21100013 T-Shirt BLACK
61783 MISHKA (ミシカ) M21100032 T-SHIRT WHITE
61765 MISHKA (ミシカ) M21100001 T-SHIRT WHITE
61817 MISHKA (ミシカ) M21100032 T-SHIRT BLACK
61767 MISHKA (ミシカ) M21100001 T-SHIRT BLACK
60294 MISHKA M61000007 T-SHIRT WHITE
60170 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE WHITE
58823 MISHKA(ミシカ) M21000015 T-SHIRTS
58822 MISHKA(ミシカ) M21000014 T-SHIRTS WHITE
58821 MISHKA(ミシカ) M21000014 T-SHIRTS PURPLE
58129 MISHKA M21000007 T-Shirt Black
58128 MISHKA M21000011 T-Shirt White
58577 MISHKA(ミシカ) M21000072 T-Shirt PURPLE
58578 MISHKA(ミシカ) M21000072 T-Shirt BLACK
57362 MISHKA M21000059 T-Shirt YELLOW
57361 MISHKA M21000059 T-Shirt BLACK
57357 MISHKA M21000030 T-Shirt WHITE
57356 MISHKA M21000030 T-Shirt BLACK
55911 MISHKA MAW200004 T-SHIRTS WHITE
55903 MISHKA x Johnny Ryan DON'T LET THEM S/S T-SHIRTS
54464 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 Tシャツ
54199 MISHKA MSS200029M80 T-SHIRTS BLACK
54197 MISHKA MSS200033F80 T-SHIRTS BLACK
21798 MISHKA (ミシカ) Familiar Faces T-Shirt
25327 MISHKA (ミシカ) CAMO KEEP WATCH TEE WHITE
29801 MISHKA KEEP WATCH TEE BLK
33650 MISHKA (ミシカ) LAMOUR K.W TEE BLK
35250 MISHKA (ミシカ) MSS170029 BLACK
35257 MISHKA (ミシカ) MSS170013 TEE
35264 MISHKA (ミシカ) MSS170052 WHITE
37084 MISHKA(ミシカ) MAW170008
38719 MISHKA (ミシカ) 2018 HAPPY BAG
38832 MISHKA (ミシカ) LAMOUR SCUM LOVE T-SHIRT FL 171116 WHT
38837 MISHKA (ミシカ) LAMOUR ON SIGHT T-SHIRT FL 171120 WHT
38844 MISHKA (ミシカ) DEATH COBRA T-SHIRT CHA
38848 MISHKA (ミシカ) LAMOUR CARE ADDER T-SHIRT FL171118 WHT
39803 MISHKA (ミシカ) MSS180028 T-Shirt Black
40648 MISHKA SP181303 FLYING TIGER KEEP WATCH TEE WHITE
40649 MISHKA SP181303 FLYING TIGER KEEP WATCH TEE ORANGE
40651 MISHKA SP181304 GUNNER KEEP WATCH TEE WHITE
40655 MISHKA SP181306 BROKEN DUCK DIVISION TEE WHITE
40661 MISHKA SP181309 WAR COMIC TEE WHITE
40670 MISHKA SP181314 UFO KEEP WATCH TEE ORANGE
41320 MISHKA MSS180010 T-shirts BLACK
41322 MISHKA SS180009 T-shirts BLACK
41340 MISHKA EX181358 DEATH INVADER TEE WHITE
41342 MISHKA EX181340 CREEPIN' IT EASY TEE BLACK
41348 MISHKA EX181356 GARBAGE PAIL ADDERS TEE BLACK
43150 MISHKA (ミシカ) EX181362 MARK DEAN VECA K.W T WHITE
45635 MISHKA MSS190065F99 T-SHIRT
45870 MISHKA MSS190046 TEE WHITE
45871 MISHKA MSS190046 TEE BLACK
47034 MISHKA SP191007 T-SHIRT WHITE
47406 MISHKA MSS190028 T-SHIRT WHITE
47411 MISHKA MSS190007 T-SHIRT YELLOW
48466 MISHKA (ミシカ) SM191003 Keep Watch Mop Tee Black
48467 MISHKA (ミシカ) SM191003 Keep Watch Mop Tee White
50565 MISHKA DEATH SKULL T-SHIRTS BLACK
51495 MISHKA MSS200054M99 T-SHIRTS BLACK
51496 MISHKA MSS200054M80 T-SHIRTS WHITE
51497 MISHKA MSS200054M12 T-SHIRTS SAFTY GREEN
51522 MISHKA MSS200020F80 T-SHIRTS WHITE
51523 MISHKA MSS200020F99 T-SHIRTS BLACK
51547 MISHKA EX1901MD T-SHIRTS BLACK
51548 MISHKA EX1902MD T-SHIRTS WHITE
51557 MISHKA FW191001 T-SHIRTS BLACK
51558 MISHKA FW191001 T-SHIRTS WHITE
51559 MISHKA FW191003 T-SHIRTS WHITE
51560 MISHKA FW191003 T-SHIRTS BLACK
51561 MISHKA FW191007 T-SHIRTS BLACK
51562 MISHKA FW191007 T-SHIRTS WHITE
51566 MISHKA FW191010 T-SHIRTS WHITE
51567 MISHKA FW191010 T-SHIRTS BLACK
51568 MISHKA FW191011 T-SHIRTS BLACK
51569 MISHKA FW191011 T-SHIRTS WHITE
52246 MISHKA MSS200006F99 T-SHIRTS BLACK
52247 MISHKA MSS200008F80 T-SHIRTS WHITE
52248 MISHKA MSS200008F53 T-SHIRTS YELLOW
52249 MISHKA MSS200008F99 T-SHIRTS BLACK
52253 MISHKA MSS200052M80 T-SHIRTS WHITE
52254 MISHKA MSS200052M99 T-SHIRTS BLACK
52255 MISHKA MSS200052M31 T-SHIRTS SLATE