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-18 12:34:15')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND pc.classcategory_id1 IN( 11)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
52942 Survive Said The Prophet MIA TOUR TEE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
52951 Survive Said The Prophet UNBALANCE TEE YELLOW
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
54615 Survive Said The Prophet TAPED LOGO TEE WHITE
54618 Survive Said The Prophet EMBRONDERY COMFORT TEE GREEN
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
17973 UNEARTH SKATE RAGE
22508 ドラマチックアラスカ 人間ロックTシャツ ゲキクロ限定カラー
23747 9mm Parabellum Bullet Photo Tシャツ
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
23749 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) NVY
26399 【限定アイテム】モーモールルギャバン ロゴTシャツ(すしおデザイン)
28694 AUGUST BURNS RED DOVE
35602 DISTURBED FIRE BEHIND T-SHIRTS
35609 FIVE FINGER DEATH PUNCH SGT MAJOR
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
39163 BLACK SABBATH LOTW white Tee
39905 SANTA CRUZ Classic Dot S/S T-Shirt White
39908 SANTA CRUZ Classic Dot S/S T-Shirt Silver
41078 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / PINK
42629 KEYTALK シンプルロゴ刺繍Tシャツ バナナ
42666 夢みるアドレセンス"メロンソーダ" 限定Tシャツ
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
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
49846 DISTURBED LOST SOULS
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
50369 MODERN DAY BABYLON Travelers T-shirt
52510 BILLIE EILISH UNISEX TEE GRAFFITI WHITE
52511 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) LIME GREEN
52513 BILLIE EILISH UNISEX TEE AGONY BLACK
52866 BILLIE EILISH UNISEX TEE AGONY WHITE
52867 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) PINK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52870 BILLIE EILISH UNISEX TEE: BLING WHITE
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
53930 KEYTALK 繋がるKEYTALKロゴTシャツ WHITE
12020 EVANESCENCE SHINE T-Shirt
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
54741 ANTHRAX UNISEX TEE: STATE OF EUPHORIA
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55734 SLAYER UNISEX TEE: SILVER EAGLE
56210 Anti Social Social Club Enrique White Vneck Tee
56213 Anti Social Social Club Headrush All Over White Tee
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
56810 AC/DC UNISEX TEE: ANGUS STATUE
57391 FILA FS3008 T-Shirt BLACK
58287 ANIMALIA AN21S-CS06 Wild Bill S/S
59117 ANIMALIA AN21U-TE11 FALLING WHITE
59233 LONELY論理 LONELY UNIV TEE white
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
59278 BABYMETAL PENTAGRAM TEE
52713 BABYMETAL UNISEX TEE: LOGO
59308 PSYCHOLOGICAL METAMORPHOSIS INVERSION LOGO TEE ORANGE
59366 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE RED
58726 GoneR -La Neta- GRL04CT002 LUZ Y SOL T-Shirts Black
58724 GoneR -La Neta- GRL04CT002 LUZ Y SOL T-Shirts Light Purple
58719 GoneR -La Neta- GRL04CT001 Mexican Flag T-Shirts Light Purple
59955 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE WHITE
60195 TWENTY ONE PILOTS UNISEX T-SHIRT: TRENCH CLIFF
60194 TWENTY ONE PILOTS UNISEX T-SHIRT: BANDITO BIRD
60208 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Partners Tシャツ
60207 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Battle Tシャツ
60048 SAMURAI CORE リンガーTEE BLUE
61207 XrossOver XOver K logo T (White)
60165 Anti Social Social Club THE REAL ME WHITE TEE
61419 VIRGO (ヴァルゴ) GLOWING EYES WHITE
61420 VIRGO (ヴァルゴ) GLOWING EYES BLACK
61637 STAPLE×Sesame Street Crew Tee
61436 glamb (グラム)×攻殻機動隊 SAC_2045 T White
61437 glamb (グラム)×攻殻機動隊 SAC_2045 T Black
61853 A FEW GOOD KIDS ICECREAM TEE WHITE
61854 A FEW GOOD KIDS ICECREAM TEE BLACK
62173 KILL STAR Dark Forces T-Shirt
62572 Survive Said The Prophet TRADITIONAL TEE
62573 Survive Said The Prophet "INFINI" TEE NATURAL
62999 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 人類代表参鋒 佐々木小次郎 "二天流" TEE
62997 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 人類代表次鋒 アダム "拳骨主義" TEE
62995 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 人類先鋒 呂布奉先 "否" TEE
62994 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 神代表先鋒 トール "雷槌" TEE
62993 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ ブリュンヒルデ「ビビってるんですか?」TEE
63365 KEYTALK【Disney】Tシャツ (ステージ) BLACK
63364 KEYTALK【Disney】Tシャツ (ステージ) WHITE
63367 KEYTALK【Disney】Tシャツ (縦割り) BLACK
63314 GoneR (ゴナー) GR33CT004 Mexican Pattern T-Sirts Army Green
63120 HEDWiNG (ヘドウィグ) Back to laughter Tie-dye T-shirt Light green
63121 HEDWiNG (ヘドウィグ) Back to laughter Tie-dye T-shirt Navy
63127 HEDWiNG (ヘドウィグ) Chrome logo T-shirt Sand beige
64075 AFFECTER (アフェクター) TAG Tee BLACK
64074 AFFECTER (アフェクター) TAG Tee BLUE
64072 AFFECTER (アフェクター) HEAVEN Tee WHITE
64198 Subciety (サブサエティ) MARIA TEE WHITE
64208 kirou school (キロウスクール) krs_00 arch logo S/S T-shirts WHITE×RED
64209 kirou school (キロウスクール) krs_00 arch logo S/S T-shirts WHITE×GREEN
64210 kirou school (キロウスクール) krs_08 JUST SLEEP S/S T-shirts WHITE
63383 Anti Social Social Club Out Of Time Blue Tee
63381 Anti Social Social Club The Notebook Orange Tee
63377 Anti Social Social Club Passing Fad Mint Tee
64310 Subciety (サブサエティ) LEAGUE TEE BLACK/YELLOW
64311 Subciety (サブサエティ) LEAGUE TEE NAVY
64316 Subciety (サブサエティ) SUPPORTER TEE BLACK
64315 Subciety (サブサエティ) SUPPORTER TEE GRAY
64314 Subciety (サブサエティ) SUPPORTER TEE WHITE
63260 沢城千春×SABBAT13×GEKIROCK CLOTHING Stand T-Shirt ORANGE
63261 沢城千春×SABBAT13×GEKIROCK CLOTHING Stand T-Shirt PURPLE
64863 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE WHITE
64864 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE LIGHT BLUE
64865 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE GRAY