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 13:34:05')
AND pc.classcategory_id1 IN( 161)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
36305 acOlaSia ▽ WHITE
36298 acOlaSia jAmmer BLACK
36299 acOlaSia jAmmer WHITE
36300 acOlaSia aSk
58743 アマツカミ 伽話/FIGMENT T-shirts
58764 SILLENT FROM ME WORDS WHITE
36294 acOlaSia sKull souris BLACK
36297 acOlaSia sKull souris WHITE
36312 acOlaSia cIgarettes BLACK
20469 RIP DESIGN WORXX SPELLタンクトップ WHT
37323 RIP DESIGN WORXX バッティーTシャツ BLK/WINE
37324 RIP DESIGN WORXX バッティーTシャツ BLK/SICK
36308 acOlaSia g◇at
42495 RIP DESIGN WORXX TIGER CAMO LOGO T-SHIRT BLACK
34365 RIP DESIGN WORXX スーパービッグポケットポロシャツ WHITE
38718 RIP DESIGN WORXX SKULLSHITコラボレギンス
20226 SILLENT FROM ME ARTIFICIAL WHT
20227 SILLENT FROM ME ARTIFICIAL BLK
20228 SILLENT FROM ME SPELL BLK
20229 SILLENT FROM ME SPELL WHT
20455 SILLENT FROM ME DIVISION BLACK
20456 SILLENT FROM ME DIVISION WHITE
23907 SILLENT FROM ME ANACHRONIC BLACK
23908 SILLENT FROM ME ANACHRONIC WHITE
36630 RIP DESIGN WORXX ショルダーラインTシャツ WHITE
36633 RIP DESIGN WORXX ショルダーラインTシャツ MINT
36634 RIP DESIGN WORXX ショルダーラインTシャツ LIGTH PURPLE
36301 acOlaSia cOntrol B
36302 acOlaSia cOntrol P
36304 acOlaSia wOlf
36306 acOlaSia ▽ BLACK
36310 acOlaSia cIgarettes color
36311 acOlaSia re:d◇ll
20221 SILLENT FROM ME CRYPTIC BLK
20222 SILLENT FROM ME CRYPTIC WHT
20453 SILLENT FROM ME QUIET BLACK
20454 SILLENT FROM ME QUIET WHITE
24546 SILLENT FROM ME DEPRESSED BLACK
24547 SILLENT FROM ME DEPRESSED WHITE
11682 アマツカミ さよなら T-shirts WHITE
14391 アマツカミ Moon Box T-Shirt Black
14392 アマツカミ Moon Box T-Shirt White
28434 SILLENT FROM ME ENCRYPTION WHT
28435 SILLENT FROM ME ENCRYPTION BLK
28436 SILLENT FROM ME TEAR WHT
28437 SILLENT FROM ME TEAR BLK
28684 SILLENT FROM ME DENSE BLACK
28685 SILLENT FROM ME DENSE WHTE
35047 SILLENT FROM ME SCRIBBLE BLK
35048 SILLENT FROM ME SCRIBBLE WHT
35058 SILLENT FROM ME POSER BLK
35059 SILLENT FROM ME POSER WHT
35495 SILLENT FROM ME MOAN TEE BLK
35496 SILLENT FROM ME MOAN TEE WHE
36452 SILLENT FROM ME DIVINITY BLACK
36453 SILLENT FROM ME DIVINITY WHITE
40829 SILLENT FROM ME BOYHOOD BLACK
40830 SILLENT FROM ME BOYHOOD WHITE
40831 SILLENT FROM ME CRY BLACK
40832 SILLENT FROM ME CRY WHITE
40833 SILLENT FROM ME MESS BLACK
40834 SILLENT FROM ME MESS WHITE
42750 SILLENT FROM ME ILLNESS BLACK
42751 SILLENT FROM ME ILLNESS WHITE
36048 SILLENT FROM ME PYRAMID -Pocket- BLACK
36049 SILLENT FROM ME PYRAMID -Pocket- WHITE
21403 アマツカミ Mice Heart T-shirts WHITE
21404 アマツカミ Mice Heart T-shirts BLACK
21405 アマツカミ Mice Heart T-shirts GRAY
37577 ライブキッズあるある 【ぼっち参戦】 BIG Tシャツ
21396 アマツカミ 「闇」 T-shirts
21397 アマツカミ 「月闇」 T-shirts
21398 アマツカミ 「病」 T-shirts
21399 アマツカミ 「月病」 T-shirts
24583 アマツカミ 「孤月」 Tシャツ WHT
24584 アマツカミ 「罪」 Tシャツ BLK
24585 アマツカミ 「罪」 Tシャツ WHT
42591 KAVANE Clothing "Fame"OVERSIZE CUTSEW(BLK)
42657 KAVANE Clothing "Fame"OVERSIZE CUTSEW(WHT)
42658 KAVANE Clothing "Fame"OVERSIZE CUTSEW(ORG)
42659 KAVANE Clothing "Drop"OVERSIZE CUTSEW(WHT)
42660 KAVANE Clothing "Drop"OVERSIZE CUTSEW(ORG)
42661 KAVANE Clothing "Drop"OVERSIZE CUTSEW(BLK)
42662 KAVANE Clothing "chapter"OVERSIZE CUTSEW(BLK)
42663 KAVANE Clothing "chapter"OVERSIZE CUTSEW(RED)
42664 KAVANE Clothing "chapter"OVERSIZE CUTSEW
48421 【ゲキクロ限定】KAVANE Clothing×ゲキクロ "MOMENT"OVERSIZE CUTSEW(purple)
49678 KAVANE Clothing "VENERABLE"OVERSIZE CUTSEW(Blk)
49679 KAVANE Clothing "VENERABLE"OVERSIZE CUTSEW(Red)
49681 KAVANE Clothing "AN"OVERSIZE CUTSEW(Ylw)
49684 KAVANE Clothing "XIX"OVERSIZE CUTSEW(Blk)
49685 KAVANE Clothing "XIX"OVERSIZE CUTSEW(Red)
49686 KAVANE Clothing "XIX"OVERSIZE CUTSEW(Ylw)
49687 KAVANE Clothing "chapter"OVERSIZE CUTSEW(Blk)
49692 KAVANE Clothing "chapter"OVERSIZE CUTSEW(Red)
49693 KAVANE Clothing "chapter"OVERSIZE CUTSEW(Ylw)
49673 acOlaSia PUNISH T
60566 アマツカミ 棘薔薇 Rose Needle Hoodie
37023 アマツカミ 溺薬 T-Shirt Black
37024 アマツカミ 溺薬 T-Shirt White
37025 アマツカミ 牡丹 T-Shirt Black
37026 アマツカミ 牡丹 T-Shirt White
37027 アマツカミ 俎上之鯉 T-Shirt Black
37028 アマツカミ 傀儡 T-Shirt Black
41546 アマツカミ 葬ル。 T-Shirt Black
41547 アマツカミ 葬ル。 T-Shirt White
41548 アマツカミ 月闇針 T-Shirt Black
41549 アマツカミ 月病針 T-Shirt White
41550 アマツカミ 狐繰 T-Shirt Black
41551 アマツカミ 狐繰 T-Shirt White
44156 アマツカミ 呪釘/Curse T-shirts Black
44157 アマツカミ 呪釘/Curse T-shirts White
49129 アマツカミ 処女/Virgin T-Shirts Black
49130 アマツカミ 処女/Virgin T-Shirts White
49131 アマツカミ 女生徒/Student T-Shirts Black
49132 アマツカミ 女生徒/Student T-Shirts White
49415 神使轟く、激情の如く。×アマツカミ コラボTシャツ White
49416 神使轟く、激情の如く。×アマツカミ コラボTシャツ Black
49666 アマツカミ 棘薔薇/Rose Needle T-Shirts Black
49667 アマツカミ 棘薔薇/Rose Needle T-Shirts White