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 18:43:25')
AND pc.classcategory_id1 IN( 12,44)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 518)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
23330 GoneR Logo T-Shirts Ver.3 - Grey
23340 GoneR Logo Ver.2 Tank-Top - White
23305 GoneR Mexican Skull T-Shirts - White
23306 GoneR Mexican Skull T-Shirts - Grey
23307 GoneR Mexican Skull T-Shirts - Black
23308 GoneR Flower Star T-Shirts - White
23309 GoneR Flower Star T-Shirts - Grey
23310 GoneR Flower Star T-Shirts - Black
23311 GoneR Message T-Shirts - White
23312 GoneR Message T-Shirts - Grey
23313 GoneR Message T-Shirts - Black
23314 GoneR Paint T-Shirts - White
23315 GoneR Paint T-Shirts - Grey
23316 GoneR Paint T-Shirts - Black
23320 GoneR Long T-Shirts - White
23321 GoneR Long T-Shirts - Grey
23322 GoneR Long T-Shirts - Black
23323 GoneR Logo T-Shirts Ver.1 - White
23324 GoneR Logo T-Shirts Ver.1 - Grey
23325 GoneR Logo T-Shirts Ver.1 - Black
23331 GoneR Logo T-Shirts Ver.3 - Black
23332 GoneR Mexican Skull Tank-Top - White
23334 GoneR Flower Star Tank-Top - White
23335 GoneR Flower Star Tank-Top - Black
23336 GoneR Paint Tank-Top - White
23337 GoneR Paint Tank-Top - Black
23338 GoneR Logo Ver.1 Tank-Top - White
23339 GoneR Logo Ver.1 Tank-Top - Black
23341 GoneR Logo Ver.2 Tank-Top - Black
23342 GoneR Mexican Skull Short Pants - Grey
23344 GoneR Mexican Skull Short Pants - Black
23345 GoneR GoneR × NEeeSAN Crew Neck Sweat - White
23346 GoneR GoneR × NEeeSAN Crew Neck Sweat - Grey
23347 GoneR GoneR × NEeeSAN Crew Neck Sweat - Black
23348 GoneR Flower Star Shirts Parka - White
23349 GoneR Flower Star Shirts Parka - Chambray
23350 GoneR Flower Star Shirts Parka - Black
24842 GoneR Photo Logo T-Shirts Black
24843 GoneR Photo Logo T-Shirts White
24844 GoneR Box Rip T-Shirts Black
24846 GoneR Box Rip T-Shirts White
24854 GoneR Cross Skull T-Shirts
24863 GoneR Logo T-Shirts Ver.2 Black
24864 GoneR Logo T-Shirts Ver.2 White
24865 GoneR Logo T-Shirts Ver.2 Grey
24872 GoneR GoneR Dot Tank-Top Black
29621 GoneR Rose Skull Base Ball T-Shirts WH-NV
29624 GoneR Flower Bolt L/S T-Shirts White
29625 GoneR Flower Bolt L/S T-Shirts D-Heather
29626 GoneR Flower Bolt L/S T-Shirts Black
29627 GoneR Mexican Bandana L/S T-Shirts White
29628 GoneR Mexican Bandana L/S T-Shirts D-Heather
29629 GoneR Mexican Bandana L/S T-Shirts Black
29630 GoneR Mexican Skull Pocket L/S T-Shirts WHITE
29631 GoneR Mexican Skull Pocket L/S T-Shirts BLACK
29632 GoneR Mexican Skull Pocket L/S T-Shirts GRAY
29633 GoneR Flannel Check Paint Shirts BlueCH
29634 GoneR Flannel Check Paint Shirts Black CH
29635 GoneR Kiriste Waffle Pull Parka White
29637 GoneR Kiriste Waffle Pull Parka Black
29638 GoneR Flower Bolt Pull Parka White
29639 GoneR Flower Bolt Pull Parka Grey
29640 GoneR Flower Bolt Pull Parka A.Green
29641 GoneR Flower Bolt Pull Parka Black
29642 GoneR Skull Heart Pull Parka White
29643 GoneR Skull Heart Pull Parka Grey
29645 GoneR Skull Heart Pull Parka Black
29646 GoneR Basic Logo Zip Parka White
29649 GoneR Basic Logo Zip Parka Black
29650 GoneR Heart Skull MA-1 Kahki
29651 GoneR Heart Skull MA-1 Black
33547 GoneR (ゴナー) Candle Mexican Skull T-Shirts White
33549 GoneR (ゴナー) Candle Mexican Skull T-Shirts Black
33551 GoneR (ゴナー) Pineapple Skull T-Shirts White
33553 GoneR (ゴナー) Pineapple Skull T-Shirts Black
33558 GoneR (ゴナー) Rose&Mexican Skull T-Shirts White
33562 GoneR (ゴナー) Candle Mexican Skull Long T-Shirts White
33563 GoneR (ゴナー) Candle Mexican Skull Long T-Shirts D.Heather
33564 GoneR (ゴナー) Candle Mexican Skull Long T-Shirts Black
33570 GoneR (ゴナー) Rose&Mexican Skull Long T-Shirts White
33573 GoneR (ゴナー) Pineapple Skull Pull Parka White
33575 GoneR (ゴナー) Pineapple Skull Pull Parka A.GREEN
33577 GoneR (ゴナー) Tie-Dyed Flower Skull Pull Parka A.GREEN
36461 GoneR Mexican Heart T-Shirts White
36462 GoneR Mexican Heart T-Shirts Orange
36463 GoneR Mexican Heart T-Shirts Black/White
36464 GoneR Mexican Heart T-Shirts Black/Red
36465 GoneR Rose『X』 T-Shirts Orange
36466 GoneR Rose『X』 T-Shirts White
36467 GoneR Rose『X』 T-Shirts Black/White
36468 GoneR Rose『X』 T-Shirts Black/Red
36475 GoneR Candle Mexican Skull Short Pants Grey
36519 GoneR Scripture MessegeT-Shirts
36521 GoneR Dread Skull T-Shirts WHITE
36610 GoneR Mexican Heart Tank-Top White
36611 GoneR Mexican Heart Tank-Top Black/White
36612 GoneR Mexican Heart Tank-Top Black/Red
36613 GoneR Candle Mexican Skull Tank Top
37397 GoneR Two Face Long T-Shirts White
37398 GoneR Two Face Long T-Shirts Black
37399 GoneR Two Face Long T-Shirts Orange
37400 GoneR Two Face Long T-Shirts Light Blue
37402 GoneR Rose Cross Long T-Shirts White
37403 GoneR Rose Cross Long T-Shirts Orange
37404 GoneR Rose Cross Long T-Shirts Black
37405 GoneR Rose Cross Long T-Shirts Yellow
37406 GoneR Rose Cross Long T-Shirts Light Blue
37407 GoneR GR15LS003 Border Long T-Shirts White Border
37408 GoneR GR15LS003 Border Long T-Shirts Red
37409 GoneR GR15LS003 Border Long T-Shirts Black
37410 GoneR GR15ZP001 Fire Mexican Skull Zip Parka White
37411 GoneR GR15ZP001 Fire Mexican Skull Zip Parka Red
37412 GoneR GR15ZP001 Fire Mexican Skull Zip Parka Black
37413 GoneR GR15ZP001 Fire Mexican Skull Zip Parka Acid Green
37415 GoneR GR15OT001 Rose Cross Coach Jacket Black
37416 GoneR GR15OT001 Rose Cross Coach Jacket Navy
37417 GoneR GR15OT002 New Logo Stadium Jamper Red
37418 GoneR GR15OT002 New Logo Stadium Jamper Black
37419 GoneR GR15OT002 New Logo Stadium Jamper Navy
38993 LiSA × GoneR Long Parka Black