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 15:25:24')
AND pc.price02 > 2727
AND price02 <= 4545
AND pc.stock > 0
AND pc.classcategory_id1 IN( 14,61,35)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
35489 RUDIE'S (ルーディーズ) SPARK-Tee BLK/WHT
35490 RUDIE'S (ルーディーズ) SPARK-T WHT/BLK
28811 RUDIE'S (ルーディーズ) PHAT-T WHT
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
4599 NIRVANA MANY Happy Face T-Shirt
10430 THRASHER (スラッシャー) TH8101 Mag LogoTee WH/BK
35655 PANTERA Red Vulgar T-Shirts
37586 MEGADETH -Dystopia-Black t-shirt
35292 SLIPKNOT PAUL GRAY
9313 MEMPHIS MAY FIRE Identity Navy Blue
9317 MEMPHIS MAY FIRE Challenger Black T-Shirt
9322 CAPTURE THE CROWN Walking Dead Black
9369 ATTILA Sugar Skull Black T-Shirt
9391 CROWN THE EMPIRE Axe Black T-Shirt
9424 WHITECHAPEL Riot Black T-Shirt
9428 THE WORD ALIVE Bullets Black T-Shirt
9430 TEXAS IN JULY Draw The Line Red/Orange Tie Dye
9433 OH SLEEPER Endseekers T-Shirt
9643 ICECREAM RACING DOG S/S T-SHIRT PURPLE
9644 SLIP&Co. BAMBINX TEE BLACK
10228 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
10242 JOB FOR A COWBOY JOB RORSCHACH T-Shirt
10261 RANCID MONSTER PRINT T-Shirt
10272 IRON MAIDEN KILLERS Large Print T-Shirt
11261 CHUNK!NO,CAPTAIN CHUNK! Bats Navy
11283 CAPTURE THE CROWN Gargoyle Black
11301 ENTER SHIKARI Texas Silver
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11311 ENTER SHIKARI Return To Black
11419 CAPTURE THE CROWN Doggie Black
11432 WHITECHAPEL Priest Black T-Shirt
11454 THE WORD ALIVE I'd Rather Die Black
11932 AC/DC THUNDER LOGO T-Shirt
11939 AMON AMARTH LOGO RUNE T-Shirt
12026 MEGADETH EXPLODING VIC T-Shirt
12162 SPITFIRE MASSACRE S/S Tee BLACK
14988 Agape Attire SON OF THE MOST HIGH TEE
15171 フクザワ 知らん女の自撮りTシャツ
15327 CHUNK!NO,CAPTAIN CHUNK! Open Your Ears Camo
15351 WHITECHAPEL Backfire Black
15378 THE SUMMER SET Logo Camo
15386 NORTHLANE Snakes Black
15409 MEMPHIS MAY FIRE Texas Torch Black
15427 THE WORD ALIVE Lighthouse Black
15428 THE WORD ALIVE REAL. Album Art Black Tank Top
15430 THE WORD ALIVE Press Photo White T-Shirt
15471 CROWN THE EMPIRE Axe Navy
15496 ALL THAT REMAINS A War You Cannot Win Black
15508 WE CAME AS ROMANS Dave & Kyle Live Black T-Shirt
15510 WE CAME AS ROMANS Hope Crest Black
15513 WE CAME AS ROMANS My Home Your Heart White
15517 WE CAME AS ROMANS Scratchy Text Dark Heather
15537 MAYDAY PARADE Chain Gang Black
15582 TEXAS IN JULY Vice Black
15584 TEXAS IN JULY Ministry Maroon
15886 フクザワ 飼われ男 Tシャツ
16616 this is not a business カタカナTシャツ
17973 UNEARTH SKATE RAGE
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]