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-04-28 03:19:03')
AND pc.classcategory_id1 IN( 17)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
35598 BRING ME THE HORIZON Alone & Depressed
39166 LINKIN PARK Eye Guts Tee
7860 BRING ME THE HORIZON Womens Suicide Season GRN
36787 METALLICA Women's St. Anger Cut Out Babydoll Black
47051 Subciety 【WOMENS】TINY TEE-THE BASE- WHITE
2173 THE BLACK DAHLIA MURDER Ritual Girls T-Shirt
2731 IRON FIST Squealer Boyfriend Tee
2813 GLAMOUR KILLS GIRLS HEARTKEY SLOUCHY CROP TOP TEE
3026 SRH Flowing Sccop Neck G/T
3617 BLACK VEIL BRIDES ANDY Babydoll
3880 EVANESCENCE WANT Babydoll
3909 ABBEY DAWN LEOPARD BOWSKULL BASIC TEE
6596 FAMOUS STARS AND STRAPS Brigade Jrs Scoop Tee
7224 FAMOUS STARS AND STRAPS Oil Spill Jrs Scoop Tee
7713 THE OFFSPRING BREAKING CHAINS Babydoll
7853 FAMOUS STARS AND STRAPS Skullifly Jrs V Neck Tee
7861 BRING ME THE HORIZON Suicide Season Girlie Red
9798 DISTURBIA CLOTHING Desert Tee Dress Girls
10248 BLINK182 BARS Babydoll T-shirt
10719 DROP DEAD CLOTHING HOME TOWN T-SHIRT GIRLS
11445 WHITECHAPEL Ouija Black Girl T-Shirt
11815 GLAMOUR KILLS GIRLS ANCHOR DOWN POCKET DRAPE TOP
11987 AVENGED SEVENFOLD REAPER REACH Babydoll T-Shirt
11992 BLACK VEIL BRIDES INFERNO Babydoll T-Shirt
13230 KILL STAR CLOTHING BITCH CRAFT CROP TOP [B]
13233 KILL STAR CLOTHING WHATEVER CROP TOP [B]
13343 IRON FIST CLOTHING LET'S MAKE MAGIC DRAPE TEE WT
13605 DROP DEAD CLOTHING MOTHER TONGUE CROP T-SHIRT
13764 REBEL8 WOMENS SCHOLARS BOYFRIEND TEE
13765 REBEL8 WOMENS GRE PURPLE LOGO BOYFRIEND TEE
13767 REBEL8 WOMENS BLACK LOGO TEE
13768 REBEL8 WOMENS WHITE LOGO TEE
13979 GLAMOUR KILLS ETERNAL DREAMER OVERSIZED DRAPE BGN
13980 GLAMOUR KILLS TAKE WHAT YOU LOVE V NECK WHITE
13982 GLAMOUR KILLS IN THE NIGHT BOYFRIEND TOP CHARCOAL
13989 GLAMOUR KILLS LUNAR ECLIPSE DRAPE
14201 DISTURBIA CLOTHING ENDARKENMENT Ladies T-SHIRT
14812 DISTURBIA CLOTHING I Want To Leave Ladies T-Shirt
14814 DISTURBIA CLOTHING BEATLESS Ladies T-Shirts
14880 SO SO HAPPY You Make Me Melt
14923 SKELANIMALS Still Foxy
15042 SKELANIMALS Full Moon
15043 SKELANIMALS Dead Or Alive
15045 SKELANIMALS Love Never Dies
15046 SKELANIMALS I Still Bite
15097 GLAMOUR KILLS CATTITUDE SCOOP NECK
15104 GLAMOUR KILLS SEIZE THE DAY SCOOP NECK
15106 GLAMOUR KILLS HERE LIES DRAPE TEE
15540 MAYDAY PARADE Ghosts Lyric White GIRLS Shirt
15768 KILL STAR CLOTHING ABRACADABRA LADIES T-SHIRT
15769 KILL STAR CLOTHING 420 WOMENST-SHIRT
16564 REBEL8 WOMENS GREY LOGO BOYFRIEND TEE
16574 REBEL8 WOMENS KILLA KOLLAGE TEE
16579 REBEL8 WOMENS BACKLOT CROP TEE
16639 DROP DEAD CLOTHING Cancel My Life T-shirt
17444 DEADHEARTZ BONEZ LOGO GIRLS TEES BLACK
17445 DEADHEARTZ BONEZ LOGO GIRLS TEES WHITE
17446 DEADHEARTZ BONEZ LOGO GIRLS TEES NAVY
17925 BRING ME THE HORIZON Sempiternal Album Tee Ladies
18035 四星球 テヘペロTシャツ ボーダー
18175 DISTURBIA CLOTHING Apathy Mineral Wash Crop
18176 DISTURBIA CLOTHING Bastards Mineral Wash Crop
18684 DISTURBIA CLOTHING Whatever T-Shirt
18685 DISTURBIA CLOTHING Bastards T-Shirt
18694 DISTURBIA CLOTHING Bastards White Crop
19976 IRON FIST CLOTHING Creepers Ss Tee
19978 IRON FIST CLOTHING WISHBONE BURNOUT TEE
20301 REBEL8 WOMENS WORSHIP WORTHY TEE
20401 DROP DEAD CLOTHING Psyched Out Dress
21392 FAMOUS STARS AND STRAPS ETERNITY Girl's Muscle Tee
21484 アーバンギャルド YOKOTAN I LOVE PARIS Tシャツ ピンク
21573 aquarifa レイ Tシャツ ウィメンズ ブラック
21574 aquarifa レイ Tシャツ ウィメンズ アクア
21612 DISTURBIA CLOTHING Chronic Youth Crop
21613 DISTURBIA CLOTHING Owl Crop
21618 DISTURBIA CLOTHING Ride Ladies Tee
21638 DISTURBIA CLOTHING Spirit Animal Ladies Tee
21639 DISTURBIA CLOTHING Sigil Ladies Tee
21640 DISTURBIA CLOTHING This World Sucks Ladies Tee
21641 DISTURBIA CLOTHING Spirit Animal Ladies Tee
22083 REBEL8 WOMENS SHORT SLEEVE SWEATER LOGO TEE
23856 FOUR GET ME A NOTS Chie Tシャツ
24454 GLAMOUR KILLS NEVER SPLIT SCOOP
24472 GLAMOUR KILLS MOONLIGHT DRAPE
24680 SLEEPING WITH SIRENS Punk Patch Black - Girls/JRS t-shirt
24743 WHITECHAPEL Metal Petals Black - Girl's T-Shirt
25014 REBEL8 LOGO S/S RAGLAN
25015 REBEL8 PREMIUM BLEND TEE
25508 WHITECHAPEL Memorial Black - Girl Shirt
27530 KILL STAR CLOTHING (キルスター・クロージング) Purr Evil T-Dress [B]
27854 DISTURBIA CLOTHING SLAY RAGLAN 3/4 TEE
27855 DISTURBIA CLOTHING YAWN RAGLAN 3/4 TEE
27856 DISTURBIA CLOTHING NO IDEA RAGLAN 3/4 TEE
27857 DISTURBIA CLOTHING SUPERGONE CROP
27858 DISTURBIA CLOTHING MISS ANTHROPY CROP
27859 DISTURBIA CLOTHING ALIEN MESH TEE
27866 DISTURBIA CLOTHING (ディスタービア・クロージング) MEGABITCH CUT-OUT
27878 DISTURBIA CLOTHING (ディスタービア・クロージング) BE ONE OF US OVERSIZED TEE
27894 DISTURBIA CLOTHING (ディスタービア・クロージング) Nightmare Nightie
28235 SRH TRIBE WOMENS TEE BLACK
28469 Gluttonous Slaughter (グラトナス・スローター) Bleed the Hallowed Blood BLACK
28838 アーバンギャルド アーバンギャルド 水玉病 Tシャツ
29109 KILL STAR CLOTHING (キルスター・クロージング) Cozmic Death Crop Top [B]
29869 REBEL8 WOMENS CENTIFOLIA RAGLAN
31709 DISTURBIA CLOTHING Britney Raglan
31710 DISTURBIA CLOTHING Art School Ragran
31711 DISTURBIA CLOTHING Zero Top
31712 DISTURBIA CLOTHING Bones Collared Top
32329 REBEL8 SKATE CORE BURNOUT TEE
33603 REBEL8 FRUITS OF LABOR ROLL SLEEVE LADIES TEE
33605 REBEL8 SHARP TOUNGE STRIPE TEE
33608 REBEL8 EIGHT OR DIE TEE
35079 REBEL8 Water Hazard Embroidered Roll Sleeve Tee
35093 REBEL8 Lakeview Embroidered Pocket Ladies Tee Black
35094 REBEL8 Lakeview Embroidered Pocket Ladies Tee White
35512 ALL TIME LOW (LIVE SHOW) Babydoll
35647 MARILYN MANSON MIRRORED DRESS T-SHIRTS
35651 MARILYN MANSON Bigger than Satan Tee Dress
36726 REBEL8 Overspray Tee
36788 DISTURBIA CLOTHING BURN CUT OUT TEE