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 20:34:51')
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
66447 MISHKA (ミシカ) M61100360 cardigan yellow green
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
2173 THE BLACK DAHLIA MURDER Ritual Girls T-Shirt
2731 IRON FIST Squealer Boyfriend Tee
2813 GLAMOUR KILLS GIRLS HEARTKEY SLOUCHY CROP TOP TEE
2851 DROP DEAD CLOTHING Girls Chillin
3026 SRH Flowing Sccop Neck G/T
3617 BLACK VEIL BRIDES ANDY Babydoll
3880 EVANESCENCE WANT Babydoll
3909 ABBEY DAWN LEOPARD BOWSKULL BASIC TEE
4795 DROP DEAD CLOTHING MONROE
5191 DROP DEAD CLOTHING SWANKY CATZ
5293 DROP DEAD CLOTHING FLORAL LEGGINGS
5676 IRON FIST CLOTHING Stop Being Useless A-Line Tank
5680 IRON FIST CLOTHING Siesta Skull Sequined Dress
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
6874 GLAMOUR KILLS GIRLS SLAY ON DRAPE 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
7853 FAMOUS STARS AND STRAPS Skullifly Jrs V Neck Tee
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
9811 DISTURBIA CLOTHING Sex Sex Sex Girls Tank Top
9837 DISTURBIA CLOTHING The Queen Is Dead Vest Dress
9868 KILL STAR CLOTHING LUNA SLOUCHY GIRLS SWEATSHIRT
10161 DROP DEAD CLOTHING Death Bed Jacket Girls
10248 BLINK182 BARS Babydoll T-shirt
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
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
13230 KILL STAR CLOTHING BITCH CRAFT CROP TOP [B]
13233 KILL STAR CLOTHING WHATEVER CROP TOP [B]
13331 IRON FIST CLOTHING MISFITS LEGGING BLACK
13333 IRON FIST CLOTHING SORCERY LEAGUE CROP MUSCLE TANK
13338 IRON FIST CLOTHING MISFITS SEQUIN TANK DRESS
13339 IRON FIST CLOTHING SKULL A DOT LEGGING
13340 IRON FIST CLOTHING SKIN CRAWLER DRESS
13343 IRON FIST CLOTHING LET'S MAKE MAGIC DRAPE TEE WT
13363 IRON FIST CLOTHING SHIP WRECKER TANK TEAL
13365 IRON FIST CLOTHING HELLWAIIN HOLIDAY DRESS
13366 IRON FIST CLOTHING CALICO JACK JERSEY ROMPER BLACK
13368 IRON FIST CLOTHING SPINELESS PETER PAN COLLAR BLOU
13605 DROP DEAD CLOTHING MOTHER TONGUE CROP T-SHIRT
13631 DROP DEAD CLOTHING DEAD SHORTS
13633 DROP DEAD CLOTHING CRAZY LIFE KNIT TOP
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
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]
14761 KILL STAR CLOTHING HEX VEST DRESS [W]
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
14980 Agape Attire DOUBLE CROSSED LEGGINGS
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
15540 MAYDAY PARADE Ghosts Lyric White GIRLS Shirt
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