SELECT SQL_CALC_FOUND_ROWS 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-04-23 22:14:49')
AND pc.stock > 0
AND pc.classcategory_id1 IN( 159)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
24329 RUDIE'S DRAWING-T BLACK
42666 夢みるアドレセンス"メロンソーダ" 限定Tシャツ
43487 KILL STAR CLOTHING Delish Relaxed Top [B]
49765 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW BLUE
49766 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW YELLOW
49767 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW GREEN
51444 JILUKA×DI:VISION ゲキクロ・コラボ・Tシャツ BLACK
52286 あゆみくりかまき×ゲキクロ×ripdw AKM TIMES T-SHIRT
52513 BILLIE EILISH UNISEX TEE AGONY BLACK
52867 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) PINK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
53957 KONUS Color Blocked Oversized Short Sleeve BLACK
11984 ANTHRAX WORSHIP MUSIC T-Shirt
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
53189 BLACK VEIL BRIDES UNISEX TEE: INFERNO
55734 SLAYER UNISEX TEE: SILVER EAGLE
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
24330 RUDIE'S DRAWING-T WHITE
56210 Anti Social Social Club Enrique White Vneck Tee
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
57798 CRADLE OF FILTH Krampus T-shirt + ornament
55636 Anti Social Social Club Kkoch Black Tee
59274 IRON MAIDEN Unisex Tee: Duality
59273 IRON MAIDEN Unisex Tee: Eddie Chained Legacy
45953 Crossfaith ORNAMENT TEE BLACK
41960 BABYMETAL Unisex Tee: Skull Sword
59278 BABYMETAL PENTAGRAM TEE
52713 BABYMETAL UNISEX TEE: LOGO
60240 acOlaSia VICTIM TEE WHITE
60246 acOlaSia MEDAMAYAKI TEE WHITE
55634 Anti Social Social Club MIND GAMES BLACK TEE
60165 Anti Social Social Club THE REAL ME WHITE TEE
62294 Zephyren(ゼファレン) S/S TEE - In vino veritas - YELLOW
63379 Anti Social Social Club Self Conclusion Sand Tee
64309 Subciety (サブサエティ) LEAGUE TEE WHITE/BLUE
64314 Subciety (サブサエティ) SUPPORTER TEE WHITE
64863 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE WHITE
64864 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE LIGHT BLUE
64889 acOlaSia (アコレイジア) HUNGRY tee WHITE
64898 acOlaSia (アコレイジア) GAMING ERROR tee BLACK
64916 ANIMALIA (アニマリア) TITLE WHITE
65009 SUPPLIER (サプライヤー) IRON LOGO RAGLAN TEE/GREEN
65279 SUPPLIER (サプライヤー) SPLR NECK LOGO TEE WHITE
65293 ハッピーハンバーグ ステーキハウス刺繍Tシャツ WHITE
65312 ZERO EVOKE Spider Tee 【PINK】
65349 SUPPLIER (サプライヤー) VENOM REFLECTOR TEE
65658 SAMURAI CORE(サムライコア) ガンズ&ザビエルTEE WHITE
65659 SAMURAI CORE(サムライコア) ガンズ&ザビエルTEE GRAY
65688 Lonesome_Blue×KAVANE Clothing×GEKIROCK CLOTHINGコラボ・Tシャツ
66964 PLEASURES(プレジャーズ) NO SMOKING T-SHIRT BROWN
66900 PLEASURES(プレジャーズ)REALITY T-SHIRTWHITE
35490 RUDIE'S (ルーディーズ) SPARK-T WHT/BLK
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
28811 RUDIE'S (ルーディーズ) PHAT-T WHT
67975 YUNGBLUD UNISEX T-SHIRT: FACE (BACK PRINT)
67974 YUNGBLUD LADIES T-SHIRT: RAVER SMILE (BACK PRINT)
67977 YUNGBLUD UNISEX T-SHIRT: R-U-OK?
64187 over print(オーバープリント) back pennant Tee (light coral pink)
68159 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE YELLOW
68079 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / BLACK
68078 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / SAX
68584 SYSTEM OF A DOWN UNISEX T-SHIRT: TOXICITY
68585 SYSTEM OF A DOWN UNISEX T-SHIRT: TRIPLE STACK BOX
68586 SYSTEM OF A DOWN UNISEX T-SHIRT: BANNER MARCHES
37811 ALL TIME LOW UNISEX TEE: SCRATCH
66966 MEGADETH UNISEX T-SHIRT: RUST IN PEACE 30TH ANNIVERSARY (BACK PRINT)
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
68737 ANIMALIA (アニマリア) HEAVY S/S TEE-FOIL PRINT LOGO BLACK
68738 ANIMALIA (アニマリア) HEAVY S/S TEE-FOIL PRINT LOGO GRAGE
68384 SABBAT13(サバトサーティーン) PLAY SONG T (BLACK)
68387 SABBAT13(サバトサーティーン) FATE T (SMOKE BLACK)
68388 SABBAT13(サバトサーティーン) FATE T (ASH)
68440 SABBAT13(サバトサーティーン) SCAPEGOAT T (BLACK)
68439 SABBAT13(サバトサーティーン) SCAPEGOAT T (WHITE)
68744 Gluttonous Slaughter(グラトナススローター) Feast of the Unbirthed T-shirt BLACK
68548 東京13零式(トウキョウイチサンゼロシキ) 滅滅 Light Purple
68549 東京13零式(トウキョウイチサンゼロシキ) 滅滅 White
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
68294 RUDIE'S (ルーディーズ) EXTRA DRAWING-T BLACK
68458 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T BLACK
67922 【BanG Dream! ×ゲキクロ 2023 ver.】氷川紗夜×Subciety コラボ Tシャツ
68008 【BanG Dream! ×ゲキクロ 2023 ver.】湊友希那×ZEPHYREN コラボ Tシャツ
68004 【BanG Dream! ×ゲキクロ 2023 ver.】パレオ×DI:VISION コラボ Tシャツ
68544 THRASHER (スラッシャー) Devils Music S/S T-SHIRTS WHITE
68545 THRASHER (スラッシャー) Gonz Thumbs Up S/S T-SHIRTS BLACK
68546 THRASHER (スラッシャー) Gonz Thumbs Up S/S T-SHIRTS WHITE
4449 THRASHER (スラッシャー) TH8101 Mag LogoTee BK/WH
28395 THRASHER (スラッシャー) TH8101 MAG LOGO TEE BURGUNDY
28396 THRASHER (スラッシャー) TH8101 MAG LOGO TEE NAV/WHT
10430 THRASHER (スラッシャー) TH8101 Mag LogoTee WH/BK
58322 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BLACK
58321 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT WHITE
68836 over print (オーバープリント) SIDE LINE Nylon Pullover LAVENDER
69027 Gurin. ×PSYCHOLOGICAL METAMORPHOSIS EYES TEE BLACK
69026 Gurin. ×PSYCHOLOGICAL METAMORPHOSIS EYES TEE WHITE
69086 ROLLING CRADLE (ローリングクレイドル) Re:STEP TEE / RED
69087 ROLLING CRADLE (ローリングクレイドル) Re:STEP TEE / WHITE
69088 ROLLING CRADLE (ローリングクレイドル) Re:LIKE A ROBBIE TEE / MELON
69089 ROLLING CRADLE (ローリングクレイドル) Re:LIKE A ROBBIE TEE / WHITE
68875 DI:VISION (ディヴィジョン) BURNED LOGO Tee BLACK
68876 DI:VISION (ディヴィジョン) BURNED LOGO Tee WHITE
68870 DI:VISION (ディヴィジョン) TRAPPED Tee BLACK
68871 DI:VISION (ディヴィジョン) TRAPPED Tee WHITE
68741 Gluttonous Slaughter(グラトナススローター) The Monster Slayer Cat T-shirt BLACK
69113 PUNK DRUNKERS(パンクドランカーズ)ABCDTEE'23 / REVIVAL BLACK
69112 PUNK DRUNKERS(パンクドランカーズ)ABCDTEE'23 / REVIVAL WHITE
69215 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt Black/Purple
69213 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt White
69211 GoneR(ゴナー) GR37CT002 Rose Ribbon T-Shirt Black/Red
68967 東京13零式(トウキョウイチサンゼロシキ) 流転 White×Gray
68968 東京13零式(トウキョウイチサンゼロシキ) 流転 White×Violet
69065 Dogmatic Gourmet x over print x RIP DESIGN WORXX ラーメンガールTシャツ BLACK