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-02 02:19:20')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 240, 120
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
60189 MY CHEMICAL ROMANCE MY CHEMICAL ROMANCE UNISEX T-SHIRT: THE BLACK PARADE COVER
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
68578 MY CHEMICAL ROMANCE UNISEX T-SHIRT: SPIDER
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
70948 SUM41 UNISEX T-SHIRT: AKNF SKELETON EUROPEAN TOUR 2022 (BACK PRINT & EX-TOUR)
70561 SUM41 UNISEX T-SHIRT: DOES THIS LOOK LIKE ALL KILLER NO FILLER EUROPEAN TOUR 20
67506 SUM41 UNISEX T-SHIRT: GRINNING SKULL
70557 SUM41 UNISEX T-SHIRT: REAPER
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
70935 BLINK-182 UNISEX T-SHIRT: OVERBOARD EVENT
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
53186 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SMILEY
51426 GREEN DAY Unisex Tee: Hypno 4
68568 GREEN DAY UNISEX T-SHIRT: FLOWER POT (WASH COLLECTION)
68569 GREEN DAY UNISEX T-SHIRT: DOOKIE LONGVIEW (WASH COLLECTION)
10258 GUNS N' ROSES CROSS T-Shirt
36663 GUNS N' ROSES BULLET LOGO
35620 GUNS N' ROSES BIG GUNS T-SHIRTS
59253 NIRVANA Unisex Tee:Xerox Happy Face Pink
59255 NIRVANA Unisex Tee:White Happy Face
4598 NIRVANA Happy Face T-Shirt
4599 NIRVANA MANY Happy Face T-Shirt
67967 NIRVANA UNISEX T-SHIRT: SORBET RAY Happy Face
68579 NIRVANA UNISEX T-SHIRT: HEART (WASH COLLECTION)
67966 NIRVANA UNISEX T-SHIRT: ANGELIC
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
59258 Kurt Cobain Unisex Tee: Coloured Side View
59264 Ed Sheeran Unisex Tee: Dashed Stage Photo
59265 Ed Sheeran Unisex Tee: Chords
59266 Ed Sheeran Unisex Tee: Divide
67954 FALL OUT BOY UNISEX T-SHIRT: POISONED YOUTH
67953 FALL OUT BOY UNISEX T-SHIRT: TAKE THIS TO YOUR GRAVE
58063 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT
58064 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TILT
58065 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TAPED
65622 やね×GALFY×GEKIROCK CLOTHING やねの犬Tシャツ BLACK
65624 やね×GALFY×GEKIROCK CLOTHING やねの犬Tシャツ WHITE
70369 Appare!×GALFY×GEKIROCK CLOTHING コラボ・Tシャツ WHITE
70837 Appare!×GALFY×GEKIROCK CLOTHING コラボ・Tシャツ BLACK
71432 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE WHITE
71433 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE BLACK
71239 TOY MACHINE (トイマシーン) TMPEST29 TALLY HO SS TEE WHITE
71238 TOY MACHINE (トイマシーン) TMPEST29 TALLY HO SS TEE BLACK
71240 TOY MACHINE (トイマシーン) TRANSMISSIONATOR EMBROIDERY SS TEE F.GREEN
71241 TOY MACHINE (トイマシーン) MARKED MONSTER EMBROIDERY SS TEE BURGANDY
70899 TOY MACHINE (トイマシーン) PUZZLE SS TEE WHITE
70900 TOY MACHINE (トイマシーン) PUZZLE SS TEE BLACK
70897 TOY MACHINE (トイマシーン) MIND CONTROL SS TEE WHITE
70898 TOY MACHINE (トイマシーン) MIND CONTROL SS TEE BLACK
71086 月に足跡を残した6人の少女達は一体何を見たのか...×アマツカミ×GEKIROCK CLOTHING スペシャル・コラボ・Tシャツ
71407 PSYCHO NATION(サイコネーション) カッティングショルダーTEE BLACKxPURPLE
71410 PSYCHO NATION(サイコネーション) メッシュアンサンブルTEE BLACKxBLACK
71399 寝田ルネ×PSYCHO NATION(サイコネーション) ゲーマーTEE WHITE
71400 寝田ルネ×PSYCHO NATION(サイコネーション) ゲーマーTEE BLACK
71402 寝田ルネ×PSYCHO NATION(サイコネーション) 巫女TEE WHITE
71403 寝田ルネ×PSYCHO NATION(サイコネーション) 巫女TEE BLACK
71405 PSYCHO NATION(サイコネーション) アイコンハトメTEE BLACK
71408 PSYCHO NATION(サイコネーション) メッシュアンサンブルTEE タイダイBLUExBLACK
71395 寝田ルネ×PSYCHO NATION(サイコネーション) デビルTEE SAX
71398 寝田ルネ×PSYCHO NATION(サイコネーション) ゲーマーTEE SAX
71401 寝田ルネ×PSYCHO NATION(サイコネーション) 巫女TEE PINK
71411 GoneR (ゴナー) Graffiti Logo T-Shirts White
71412 GoneR (ゴナー) Graffiti Logo T-Shirts Charcoal
71413 GoneR (ゴナー) Graffiti Logo T-Shirts Black
69879 PUNK DRUNKERS(パンクドランカーズ) ピン抜くゲームTEE - WHITE
69889 PUNK DRUNKERS(パンクドランカーズ) 毒キノコTEE - S.PINK
69888 PUNK DRUNKERS(パンクドランカーズ) 毒キノコTEE - D.BLUE
69874 PUNK DRUNKERS(パンクドランカーズ) [PDSxチャーミーちゃん]遊泳禁止TEE - PURPLE
71266 SCENE TOKYO (シーントウキョウ) soft cream Tee (sulate)
71313 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 FACES
64257 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Natural)
64267 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Gray)
64266 RIPNDIP (リップンディップ) Lord Nermal Pocket tee (Black Mineral Wash)
70875 RIPNDIP(リップンディップ) LORD NERMAL POCKET TEE (BLACK LIGHTNING WASH)
64306 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Black)
64327 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (White)
70876 RIPNDIP(リップンディップ) TRAVIS TEE (NATURAL)
70877 RIPNDIP(リップンディップ) MCFUCKIN TEE (NATUAL)
70878 RIPNDIP(リップンディップ) RISE N GRIND TEE
70373 チェンソーマン×glamb(グラム) Pochita Pocket T / ポチタポケットT WHITE
70372 チェンソーマン×glamb(グラム) Pochita Pocket T / ポチタポケットT BLACK
70249 ジョジョの奇妙な冒険xglamb(グラム) Jonathan Joestar T-shirts / ジョナサンジョースターTシャツ WHITE
70250 ジョジョの奇妙な冒険xglamb(グラム) Jonathan Joestar T-shirts / ジョナサンジョースターTシャツ BLACK
71253 SCENE TOKYO (シーントウキョウ) TYO girl Tee (white)
71254 SCENE TOKYO (シーントウキョウ) TYO girl Tee (black)
71263 SCENE TOKYO (シーントウキョウ) NFT girl Tee (white)
71264 SCENE TOKYO (シーントウキョウ) NFT girl Tee (black)
71255 SCENE TOKYO (シーントウキョウ) game girl Tee (white)
71260 SCENE TOKYO (シーントウキョウ) game girl Tee (indigo)
71258 SCENE TOKYO (シーントウキョウ) PPL girl Tee (white)
71275 SCENE TOKYO (シーントウキョウ) PPL girl Tee (indigo)
71262 SCENE TOKYO (シーントウキョウ) Devil girl Tee (apricott)
71261 SCENE TOKYO (シーントウキョウ) Devil girl Tee (sumi)
71259 SCENE TOKYO (シーントウキョウ) Maria Tee (pigment black)
71267 SCENE TOKYO (シーントウキョウ) ice girl Tee (white)
71269 SCENE TOKYO (シーントウキョウ) ice girl Tee (melon)
71271 SCENE TOKYO (シーントウキョウ) ice girl Tee (banana)
71265 SCENE TOKYO (シーントウキョウ) soft cream Tee (white)
71268 SCENE TOKYO (シーントウキョウ) family Tee (white)
71270 SCENE TOKYO (シーントウキョウ) family Tee (black)
71273 SCENE TOKYO (シーントウキョウ) roroharo Tee (white)
71274 SCENE TOKYO (シーントウキョウ) roroharo Tee (sumi)
71256 SCENE TOKYO (シーントウキョウ) togetoge KNIGHT Tee (pigment olive)
71272 SCENE TOKYO (シーントウキョウ) togetoge KNIGHT Tee (pigment black)
70751 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident TEE WHITE
70754 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident TEE YELLOW
70753 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident TEE BLUE
70752 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident TEE BLACK
70745 攻殻機動隊 STAND ALONE COMPLEX x Subciety SECTION9 TEE WHITE
70747 攻殻機動隊 STAND ALONE COMPLEX x Subciety episodes TEE WHITE/BLACK
69873 PUNK DRUNKERS(パンクドランカーズ) [PDSxチャーミーちゃん]遊泳禁止TEE - BLACK