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-10 02:08:54')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.price02 > 2727
AND price02 <= 4545
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
23747 9mm Parabellum Bullet Photo Tシャツ
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
23749 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) NVY
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
42629 KEYTALK シンプルロゴ刺繍Tシャツ バナナ
42666 夢みるアドレセンス"メロンソーダ" 限定Tシャツ
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
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
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
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
56810 AC/DC UNISEX TEE: ANGUS STATUE
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
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シャツ
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
64075 AFFECTER (アフェクター) TAG Tee BLACK
64074 AFFECTER (アフェクター) TAG Tee BLUE
64072 AFFECTER (アフェクター) HEAVEN 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
64855 Wall Of Graphic(ウォールオブグラフィック)リアム Tシャツ
64859 Wall Of Graphic(ウォールオブグラフィック)WG2 Tシャツ ブラック
64894 kirou school (キロウスクール) krs_09 "GSD" T-shirts BLACK
64896 kirou school (キロウスクール) krs_010 KRSC T-shirts WHITE
64897 kirou school (キロウスクール) krs_010 KRSC T-shirts STONE BLUE
64936 kirou school (キロウスクール) krs_011 counter logo S/S T-shirts BLACK
65272 kirou school (キロウスクール) krs_012 cheat S/S T-shirts BLACK
65273 kirou school (キロウスクール) krs_012 cheat S/S T-shirts WHITE
62849 PSYCHOLOGICAL METAMORPHOSIS COLLEGE WIDE TEE - BLACK
65288 ハッピーハンバーグ ステーキハウス刺繍Tシャツ NAVY
65312 ZERO EVOKE Spider Tee 【PINK】
65606 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (GR)
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?
67976 YUNGBLUD UNISEX T-SHIRT: WEIRD FLAMING SKELETONS (BACK PRINT)
68159 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE YELLOW
68158 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE WHITE
68079 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / BLACK
53874 MY CHEMICAL ROMANCE COFFIN T-Shirts
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
66941 BAD RELIGION UNISEX T-SHIRT: BURNING BLACK
66966 MEGADETH UNISEX T-SHIRT: RUST IN PEACE 30TH ANNIVERSARY (BACK PRINT)
66968 MEGADETH UNISEX T-SHIRT: PEACE SELLS… TRACK LIST (BACK PRINT)
66967 MEGADETH UNISEX T-SHIRT: KILLING IS MY BUSINESS (BACK PRINT)
35655 PANTERA Red Vulgar T-Shirts
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
68742 Gluttonous Slaughter(グラトナススローター) Ghoulish Harvest ビッグシルエットTシャツ BLACKxGRAY
68607 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH GRADATION TEE YELLOW
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
68572 IRON MAIDEN UNISEX T-SHIRT: THE FUTURE PAST TOUR '23 GREYSCALE
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
68543 THRASHER (スラッシャー) Devils Music S/S T-SHIRTS BLACK
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