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 19:49:00')
AND pc.stock > 0
AND FIND_IN_SET(2, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 60
22508 ドラマチックアラスカ 人間ロックTシャツ ゲキクロ限定カラー
28546 【限定アイテム】ササノマリイ M(OTHER) Tシャツ
26442 【ゲキクロ限定】amazarashi sekaibuki T-shirt L.V edition typeB
54619 Survive Said The Prophet EMBRONDERY COMFORT TEE GRAY
11301 ENTER SHIKARI Texas Silver
19134 SLEEPING WITH SIRENS Tough As Nails Silver T-Shirt
24756 WHITECHAPEL Sawblade Maroon on Charcoal - T-Shirt
11278 DANGERKIDS CAD Charcoal T-Shirt
15517 WE CAME AS ROMANS Scratchy Text Dark Heather
18972 MEMPHIS MAY FIRE Blue Fun Crest Heather
18973 MEMPHIS MAY FIRE BLUE LOGO HEATHER GREY
21115 ISSUES Too Many Moons Heather Tank Top
25148 WE CAME AS ROMANS Slytherin' Carcoal - T-Shirt
36662 GUNS N' ROSES BULLET CLASSIC GRAY
35598 BRING ME THE HORIZON Alone & Depressed
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
35690 NIRVANA Bleach Cassette Photo T-shirt
36618 RIP DESIGN WORXX エレメントTシャツ GRAY
39908 SANTA CRUZ Classic Dot S/S T-Shirt Silver
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
56811 AC/DC UNISEX FASHION TEE: BLACK ICE (BURN OUT)
68839 SLIPKNOT UNISEX T-SHIRT: AMUSEMENT PARK (BACK PRINT)
70557 SUM41 UNISEX T-SHIRT: REAPER
71007 PUNK DRUNKERS クレイジーマウスTEE - SUMI
68041 NieR (ニーア) フード付き半袖PARKA【ぐれまる】
71412 GoneR (ゴナー) Graffiti Logo T-Shirts Charcoal
11229 Nine Microphones HEAVEN S/S Gray
21118 WE CAME AS ROMANS Horse & Rider All-Over-Print
68309 over print (オーバープリント) BOWLING Tee (ash gray)
68388 SABBAT13(サバトサーティーン) FATE T (ASH)
69270 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE ASH
69871 PUNK DRUNKERS(パンクドランカーズ) [PDSxキン肉マン]ブラックホールTEE / REVIVAL - SLATE
22099 FUZZ REZ ZWEEP MODULATION TEE GRY
64267 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Gray)
64262 RIPNDIP (リップンディップ) Nerm Cruiser Tee (Black Mineral Wash)
64264 RIPNDIP (リップンディップ) Abduction Tee (Black Mineral Wash)
71545 パラッパラッパー ピグメント加工シングパラッパロゴプリントTee LIGHT GRAY
20065 ICECREAM VARSITY GREY
20067 ICECREAM ICEFA HEATHER GREY
60223 NieR (ニーア) 襟付きGRAY RIB CUTSEW【ネクタイセット】
20758 Subciety POCKET TEE S/S-GLORIOUS- GRAY
64266 RIPNDIP (リップンディップ) Lord Nermal Pocket tee (Black Mineral Wash)
66860 RIPNDIP (リップンディップ) Already Won Tee Charcoal
13399 ICECREAM FAST DOG TEE SU14 GRAY
24768 NORTHLANE All-Over Print Black - T-Shirt
29589 ICECREAM ICJP16T034 T-SHIRT GRAY
64315 Subciety (サブサエティ) SUPPORTER TEE GRAY
67882 RIPNDIP (リップンディップ) Charanerm Tee Charcoal
69592 RIPNDIP (リップンディップ) SUSHI NERM TEE (GREY)
71041 over print (オーバープリント) PIZZA PRICE Tee ash gray
71060 over print (オーバープリント) ANTI HEART Tee ash gray
71318 over print (オーバープリント) EAT A PIZZA Tee ash gray
58095 WASTED PARIS T-shirt Marble Dye Nebula Green
58096 WASTED PARIS T-shirt Marble Dye Nebula Gray
65435 RIPNDIP (リップンディップ) OG Prisma Short Sleeve Tee (Slate Grey)
65659 SAMURAI CORE(サムライコア) ガンズ&ザビエルTEE GRAY
68738 ANIMALIA (アニマリア) HEAVY S/S TEE-FOIL PRINT LOGO GRAGE
58163 NOT COMMON SENSE HARD CORE TEE BLACK
58164 NOT COMMON SENSE DEAD TUDE TEE BLACK