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 dtb_products AS p
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-25 23:14:32')
AND pc.classcategory_id1 IN( 16)
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
40957 DISTURBIA CLOTHING Peggy Stud Trousers
36787 METALLICA Women's St. Anger Cut Out Babydoll Black
47051 Subciety 【WOMENS】TINY TEE-THE BASE- WHITE
1293 SO SO HAPPY Ozzie Hoodie In Blue
2813 GLAMOUR KILLS GIRLS HEARTKEY SLOUCHY CROP TOP TEE
3617 BLACK VEIL BRIDES ANDY Babydoll
3880 EVANESCENCE WANT Babydoll
5293 DROP DEAD CLOTHING FLORAL LEGGINGS
6595 FAMOUS STARS AND STRAPS Stone BOH Jrs Derby Tank
6596 FAMOUS STARS AND STRAPS Brigade Jrs Scoop Tee
6599 FAMOUS STARS AND STRAPS Foundation Jrs Lucky Tank
7223 FAMOUS STARS AND STRAPS Lips Jrs Derby Tank
7224 FAMOUS STARS AND STRAPS Oil Spill Jrs Scoop Tee
7487 TONIGHT ALIVE Tonight Alive Heart Script Eco Grey.
7511 DROP DEAD CLOTHING LEOVEPARD TOP
7650 DISTURBIA CLOTHING Monk Vest Dress
7713 THE OFFSPRING BREAKING CHAINS Babydoll
7861 BRING ME THE HORIZON Suicide Season Girlie Red
8610 DROP DEAD CLOTHING YUM LEGGINGS
8875 DROP DEAD CLOTHING DOOM CARDIGAN
9453 GLAMOUR KILLS GIRLS GK ACADEMY VARSITY JACKET
9798 DISTURBIA CLOTHING Desert Tee Dress Girls
9808 DISTURBIA CLOTHING Negative Creep Girls Tank Top
10161 DROP DEAD CLOTHING Death Bed Jacket Girls
10191 KILL STAR CLOTHING GOETIA LEGGINGS
10230 BLACK VEIL BRIDES RAVEN Babydoll
10719 DROP DEAD CLOTHING HOME TOWN T-SHIRT GIRLS
10730 DROP DEAD CLOTHING KILLER DRESS GIRLS
10806 DROP DEAD CLOTHING ROSY LEGGINGS GIRLS
10810 DROP DEAD CLOTHING KILLER LEGGINGS GIRLS
11445 WHITECHAPEL Ouija Black Girl T-Shirt
11625 KILL STAR CLOTHING KAWAII LEGGINGS
11626 KILL STAR CLOTHING SIAMESE LEGGINGS
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
12023 DISTURBIA CLOTHING Wednesday Dress
12651 KILL STAR CLOTHING BLACK MAGIC GIRLS T-SHIRT [B]
13230 KILL STAR CLOTHING BITCH CRAFT CROP TOP [B]
13233 KILL STAR CLOTHING WHATEVER CROP TOP [B]
13340 IRON FIST CLOTHING SKIN CRAWLER DRESS
13363 IRON FIST CLOTHING SHIP WRECKER TANK TEAL
13605 DROP DEAD CLOTHING MOTHER TONGUE CROP T-SHIRT
13631 DROP DEAD CLOTHING DEAD SHORTS
13780 RUDIE'S STITCH GIRLS PULLOVER SW BLACK
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
13983 GLAMOUR KILLS VEGA LEGGINGS
13984 GLAMOUR KILLS VEGA DRESS
13989 GLAMOUR KILLS LUNAR ECLIPSE DRAPE
14201 DISTURBIA CLOTHING ENDARKENMENT Ladies T-SHIRT
14571 SO SO HAPPY Tribe Hoodie In Blue
14572 SO SO HAPPY iJustine Winkle Pink Limited Edition
14573 SO SO HAPPY Lucky Daisy Hoodie In White
14575 SO SO HAPPY Mens Mix Tape Hoodie In Pink
14576 SO SO HAPPY Tribe Hoodie In Green
14579 SO SO HAPPY SIQ Hoodie In Pink and Black
14760 KILL STAR CLOTHING HEX VEST DRESS [B]
14812 DISTURBIA CLOTHING I Want To Leave Ladies T-Shirt
14814 DISTURBIA CLOTHING BEATLESS Ladies T-Shirts
14815 DISTURBIA CLOTHING THURSDAY DRESS
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
15105 GLAMOUR KILLS STAR GAZER PULLOVER
15106 GLAMOUR KILLS HERE LIES DRAPE TEE
15109 KILL STAR CLOTHING DOLLAR SKATER DRESS [B]
15139 DROP DEAD CLOTHING Dark Hand Kimono Long
15140 DROP DEAD CLOTHING Dark Hand Kimono Short
15144 DROP DEAD CLOTHING Majic Dress
15158 DROP DEAD CLOTHING BLACK STABBATH LEGGINS
15360 KILL STAR CLOTHING TARTAN SKATER DRESS
15431 THE WORD ALIVE Press Photo White Girl's Tank Top
15768 KILL STAR CLOTHING ABRACADABRA LADIES T-SHIRT
15769 KILL STAR CLOTHING 420 WOMENST-SHIRT
15949 DROP DEAD CLOTHING Snow Parka Green Ladies
16564 REBEL8 WOMENS GREY LOGO BOYFRIEND TEE
16574 REBEL8 WOMENS KILLA KOLLAGE TEE
16579 REBEL8 WOMENS BACKLOT CROP TEE
16590 KILL STAR CLOTHING KABBALAH HOOD DRESS [B]
16591 KILL STAR CLOTHING LUNAR SKATER DRESS [B]
16592 KILL STAR CLOTHING MOONCHILD SKATER DRESS [B]
16600 KILL STAR CLOTHING ZERO TUNIC DRESS [B]
16639 DROP DEAD CLOTHING Cancel My Life T-shirt
16643 DROP DEAD CLOTHING Gerald Jumper
16645 DROP DEAD CLOTHING Bad Luck Jumper
16776 FAMOUS STARS AND STRAPS GOTHIC ROSBUD JRS FLOWY
17504 DROP DEAD CLOTHING For Your Pleasure Crewneck
17508 DROP DEAD CLOTHING Join Us Crop Top
17554 KILL STAR CLOTHING THIRD EYE SKATER DRESS [B]
17555 KILL STAR CLOTHING GOETIA HOOD DRESS [B]
18035 四星球 テヘペロTシャツ ボーダー
18057 KILL STAR CLOTHING TOO WEIRD TO LIVE VEST DRESS[B]
18175 DISTURBIA CLOTHING Apathy Mineral Wash Crop
18176 DISTURBIA CLOTHING Bastards Mineral Wash Crop
18179 DISTURBIA CLOTHING Bad Habit Overdyed Plaid Dress
18182 DISTURBIA CLOTHING Hater Acid Wash Jeans
18184 DISTURBIA CLOTHING Alien Nation Dip Dye Shirt
18186 DISTURBIA CLOTHING D'arcy Corduroy Pinafore Dress
18683 DISTURBIA CLOTHING Kiss My Ass Acid Wash Shorts
18684 DISTURBIA CLOTHING Whatever T-Shirt
18685 DISTURBIA CLOTHING Bastards T-Shirt
18687 DISTURBIA CLOTHING Whatever Mineral Wash VestDress
18688 DISTURBIA CLOTHING Night Visions Mineral Wash Vest
18689 DISTURBIA CLOTHING DeadCool Mineral Wash VestDress
18690 DISTURBIA CLOTHING Beware Mineral Wash Vest Dress
18692 DISTURBIA CLOTHING Neuron Tie-Dye Vest Dress
18693 DISTURBIA CLOTHING Come Undone Vest Dress
18694 DISTURBIA CLOTHING Bastards White Crop
18695 DISTURBIA CLOTHING Whatever White Vest Dress
18696 DISTURBIA CLOTHING Beware White Vest Dress