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 09:15:01')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 7
AND `category_type` IS NULL
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 120, 120
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
35655 PANTERA Red Vulgar T-Shirts
12067 PANTERA HOSTILE SKULL T-Shirt
66967 MEGADETH UNISEX T-SHIRT: KILLING IS MY BUSINESS (BACK PRINT)
66968 MEGADETH UNISEX T-SHIRT: PEACE SELLS… TRACK LIST (BACK PRINT)
66966 MEGADETH UNISEX T-SHIRT: RUST IN PEACE 30TH ANNIVERSARY (BACK PRINT)
37586 MEGADETH -Dystopia-Black t-shirt
36681 MEGADETH MEGADETH YAMAHA DRUMS
66941 BAD RELIGION UNISEX T-SHIRT: BURNING BLACK
37811 ALL TIME LOW UNISEX TEE: SCRATCH
68584 SYSTEM OF A DOWN UNISEX T-SHIRT: TOXICITY
68586 SYSTEM OF A DOWN UNISEX T-SHIRT: BANNER MARCHES
53874 MY CHEMICAL ROMANCE COFFIN T-Shirts
67976 YUNGBLUD UNISEX T-SHIRT: WEIRD FLAMING SKELETONS (BACK PRINT)
35292 SLIPKNOT PAUL GRAY
60194 TWENTY ONE PILOTS UNISEX T-SHIRT: BANDITO BIRD
60195 TWENTY ONE PILOTS UNISEX T-SHIRT: TRENCH CLIFF
60196 TWENTY ONE PILOTS UNISEX T-SHIRT: TORCH BEARERS
59273 IRON MAIDEN Unisex Tee: Eddie Chained Legacy
59274 IRON MAIDEN Unisex Tee: Duality
57798 CRADLE OF FILTH Krampus T-shirt + ornament
55732 SLAYER UNISEX TEE: REPENTLESS
56810 AC/DC UNISEX TEE: ANGUS STATUE
55718 ASKING ALEXANDRIA UNISEX TEE: SKULL SHIELD (RETAIL PACK)
55722 CROWN THE EMPIRE UNISEX TEE: SACRIFICE (RETAIL PACK)
11984 ANTHRAX WORSHIP MUSIC T-Shirt
12020 EVANESCENCE SHINE T-Shirt
53189 BLACK VEIL BRIDES UNISEX TEE: INFERNO
54740 ANTHRAX UNISEX TEE: AMONG THE LIVING
54741 ANTHRAX UNISEX TEE: STATE OF EUPHORIA
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55734 SLAYER UNISEX TEE: SILVER EAGLE
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
4349 ENTER SHIKARI Destabilize Tour Black
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
7432 WOE IS ME Griffin Black
9317 MEMPHIS MAY FIRE Challenger Black T-Shirt
9322 CAPTURE THE CROWN Walking Dead Black
9369 ATTILA Sugar Skull Black T-Shirt
9391 CROWN THE EMPIRE Axe Black T-Shirt
9424 WHITECHAPEL Riot Black T-Shirt
9428 THE WORD ALIVE Bullets Black T-Shirt
9433 OH SLEEPER Endseekers T-Shirt
10228 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
10242 JOB FOR A COWBOY JOB RORSCHACH T-Shirt
10272 IRON MAIDEN KILLERS Large Print T-Shirt
11236 WOE IS ME Circus Revenge Black
11257 A SKYLIT DRIVE Gorilla Vs. Raptor Black
11283 CAPTURE THE CROWN Gargoyle Black
11284 ENTER SHIKARI Stealth Black
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11311 ENTER SHIKARI Return To Black
11419 CAPTURE THE CROWN Doggie Black
11432 WHITECHAPEL Priest Black T-Shirt
11440 TEXAS IN JULY Bed Of Nails Black
11445 WHITECHAPEL Ouija Black Girl T-Shirt
11451 TEXAS IN JULY Without A Head! Black
11454 THE WORD ALIVE I'd Rather Die Black
11932 AC/DC THUNDER LOGO T-Shirt
11939 AMON AMARTH LOGO RUNE T-Shirt
12026 MEGADETH EXPLODING VIC T-Shirt
15342 WHITECHAPEL Doom Black
15351 WHITECHAPEL Backfire Black
15386 NORTHLANE Snakes Black
15408 MEMPHIS MAY FIRE Red Logo Black
15409 MEMPHIS MAY FIRE Texas Torch Black
15427 THE WORD ALIVE Lighthouse Black
15428 THE WORD ALIVE REAL. Album Art Black Tank Top
15435 PIERCE THE VEIL Logo Black
15436 PIERCE THE VEIL Seal Black T-Shirt
15437 THE WORD ALIVE Poseiden Black
15464 MOTIONLESS IN WHITE Raven Black TEE
15467 CHIODOS This Is Love Band - T-Shirt
15496 ALL THAT REMAINS A War You Cannot Win Black
15508 WE CAME AS ROMANS Dave & Kyle Live Black T-Shirt
15509 WE CAME AS ROMANS Reasons Black
15510 WE CAME AS ROMANS Hope Crest Black
15532 MAYDAY PARADE Photo Black
15535 MAYDAY PARADE Broken Heart Black
15537 MAYDAY PARADE Chain Gang Black
15582 TEXAS IN JULY Vice Black
15601 TEXAS IN JULY Draw The Line Black Tie Dye
17973 UNEARTH SKATE RAGE
18979 MEMPHIS MAY FIRE Nautical Black
18981 MEMPHIS MAY FIRE Cartoon Matty Black
19001 WHITECHAPEL Pocket Blade Black
19004 WHITECHAPEL Simple Flag Black
19093 ATTILA South By Suck My Fuck Black
19095 ATTILA Biker Black T-Shirt
19096 ATTILA Bad Reputation Black
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
19881 TEXAS IN JULY Brain Black
19884 WITHIN THE RUINS Agent Of Chaos Black
19894 FINCH Hand Heather RED T-Shirt
20216 【激ロック限定デザイン】NINJA KORE THE NINJA
20217 【激ロック限定デザイン】NINJA KORE MR.BOMB
20553 PALISADES Wolves...TS Black
21124 ATTILA Dirty Black
21125 BEARTOOTH Generation Of Disorder Black
24541 ATTILA Fuck Your Shit Camo Black - T-Shirt
24662 ISSUES I Have Issues Black - T-Shirt
24672 SLEEPING WITH SIRENS Floral Black - T-Shirt
24679 SLEEPING WITH SIRENS Sealed Lips Black - T-Shirt
24680 SLEEPING WITH SIRENS Punk Patch Black - Girls/JRS t-shirt
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
24704 MEMPHIS MAY FIRE Smokey Black - T-Shirt
24748 WHITECHAPEL Pyro Black - T-Shirt
24755 WHITECHAPEL Crate Black - T-Shirt
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
24758 WHITECHAPEL Sawblade Camo on Black - T-Shirt
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
25127 THE STORY SO FAR Snakes Black - T-Shirt
25132 SEAWAY Colour Blind Logo Black - T-Shirt
25137 SEAWAY Crystal Ball Black - T-Shirt
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
25193 IWRESTLEDABEARONCE Witch Black - T-Shirt