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-24 23:44:47')
AND FIND_IN_SET(6, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 60
17928 BRING ME THE HORIZON SCHOOL GIRL
21575 aquarifa レイ Tシャツ ナチュラル
23937 amazarashi higashizm character T-shirts
23938 amazarashi 0.7 mitsume T-shirt 【黄】
23942 amazarashi nee mama [boy T-shirt] 【ナチュラル】
26149 ARCHITECTS Bird
26151 I KILLED THE PROM QUEEN Beloved Coffin
28567 A DAY TO REMEMBER BAD APPLE T-Shirts
36856 RED HOT CHILI PEPPERS Looking Around-Natural t-shirt
41757 Survive Said The Prophet LOGO POCKET BOX TEE (BEIGE)
42592 KEYTALK ミルクTシャツ
49836 LINKIN PARK Yellow Logo t-shirt
54415 ROLLING CRADLE DRAW LOGO SUPER BIG TEE / BEIGE
54429 【BTS着用モデル】 FILA FFM9357 T-shirts OffWhite
54745 Dezzn Oversized Hooded T-Shirt Beige
53251 Zephyren(ゼファレン)SWITCHING TEE S/S WHITE / RELIGION
55951 Gluttonous Slaughter (グラトナス・スローター) Triple Six big T-shirt Beige
55912 MISHKA MAW200004 T-SHIRTS BEIGE
55810 PUNK DRUNKERS 顔コンペTEE'20 - SAND.KHAKI
57392 FILA FS3021 T-Shirt CHARCOAL
58325 THRASHER (スラッシャー) TH91291 40TH T-SHIRT BEIGE
57151 SABBAT13 CREEPY BIG T BEIGE
58407 RUDIE'S GUESTPASS-T CORALBEIGE
58509 THRASHER (スラッシャー) TH8101 MAG LOGO S/S TEE KHARKI/BLACK
58527 ぜんぶ君のせいだ。×GEKIROCK CLOTHING×UNUSUAL コラボTシャツ メイユイメイ
58549 【予約商品】SABBAT13 GHOST POCKET T キャメル
58555 SABBAT13 MALUS T コーラルベージュ
58557 SABBAT13 SUPPER T ベージュ
58082 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN FAMILY-T NATURAL
59291 GoneR GR29CT004 Mexican Round Design T-Shirts Vintage Natural
58701 GoneR GR29CT003 Rose Messege T-Shirts Stone
60112 Gluttonous Slaughter (グラトナス・スローター) DOOM Big T-shirt Beige
59125 PUNK DRUNKERS[PDSxPAC-MAN]GAMER.TEE - C.BEIGE
60234 NieR (ニーア) LOGO刺繍CUTSEW【BEIGE】
57270 BRING ME THE HORIZON UNISEX TEE: FLOWERS (BACK PRINT)
60250 ROLLING CRADLE MAGAZINE TEE / BEIGE
60251 ROLLING CRADLE COSPLAY GIRL-MOON- TEE / BEIGE
60109 LONELY論理 ANTI V.A T-SHIRTS BEIGE
60602 RIPNDIP Logo Embroidered Tee (Natural Speckle)
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
60957 PUNK DRUNKERS [PDSxチャーミーちゃん]チャーミーちゃんとアイツBIG.TEE - LT.PINK
62573 Survive Said The Prophet "INFINI" TEE NATURAL
63663 Gluttonous Slaughter Nyangoro the Fishmonger Ultra Heavy T-shirt
63127 HEDWiNG (ヘドウィグ) Chrome logo T-shirt Sand beige
63350 ROLLING CRADLE (ローリングクレイドル) CYCLOPS TOY PACKAGE TEE / SAND
63114 Subciety (サブサエティ) INVOICE TEE BEIGE
63111 Subciety (サブサエティ) SCOUT TEE BEIGE
62673 PUNK DRUNKERS (パンクドランカーズ) メニメニプリントTEE - S.BEIGE
64945 A FEW GOOD KIDS (アフューグッドキッズ) EMBROIDERY THREE-DIMENSIONAL LOGO TEE BEIGE
64148 SABBAT13(サバトサーティーン) STORY TELLING T (BG)
65023 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (BG)
60968 PUNK DRUNKERS 切断アイツTEE - S.BEIGE
62687 PUNK DRUNKERS (パンクドランカーズ) うさちゃんBIG.TEE - LT.PINK
58126 MISHKA M21000006 T-Shirt Beige
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
67886 RIPNDIP (リップンディップ) Great Wave Tee (Sage)
63735 over print (オーバープリント) EMB logo Tee 1 (light coral pink)
63008 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - SAND