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-26 11:26:14')
AND pc.stock > 0
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 360, 120
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
15466 CHIODOS Chaos White T-Shirt
15467 CHIODOS This Is Love Band - T-Shirt
15471 CROWN THE EMPIRE Axe Navy
15481 ATTILA Kings Black Crewneck
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
15513 WE CAME AS ROMANS My Home Your Heart White
15515 WE CAME AS ROMANS Ancestor Heather Grey Tank Top
15517 WE CAME AS ROMANS Scratchy Text Dark Heather
15532 MAYDAY PARADE Photo Black
15535 MAYDAY PARADE Broken Heart Black
15537 MAYDAY PARADE Chain Gang Black
15540 MAYDAY PARADE Ghosts Lyric White GIRLS Shirt
15579 SECRETS Heart Black Tank Top
15582 TEXAS IN JULY Vice Black
15584 TEXAS IN JULY Ministry Maroon
15601 TEXAS IN JULY Draw The Line Black Tie Dye
17973 UNEARTH SKATE RAGE
18972 MEMPHIS MAY FIRE Blue Fun Crest Heather
18973 MEMPHIS MAY FIRE BLUE LOGO HEATHER GREY
18979 MEMPHIS MAY FIRE Nautical Black
18980 MEMPHIS MAY FIRE Eagle Dagger Red
18981 MEMPHIS MAY FIRE Cartoon Matty Black
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
18983 WE CAME AS ROMANS Wont Fade Away Navy
18984 WE CAME AS ROMANS Varsity Custom Heather Grey Crew
18987 WE CAME AS ROMANS Howl At The Moon White
18988 WE CAME AS ROMANS Floral Script HeatherMountain
19001 WHITECHAPEL Pocket Blade Black
19004 WHITECHAPEL Simple Flag Black
19010 WHITECHAPEL Thirst Black
19014 REVOCATION Deathless Album Black
19093 ATTILA South By Suck My Fuck Black
19095 ATTILA Biker Black T-Shirt
19096 ATTILA Bad Reputation Black
19100 ATTILA Guilty Pleasure Black Crewneck
19104 ATTILA RAGEAHOLICS WHITE
19134 SLEEPING WITH SIRENS Tough As Nails Silver T-Shirt
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
19821 MAYDAY PARADE Label Crimson Tie Dye
19835 THE SUMMER SET Floral Triangle Teal
19836 MAYDAY PARADE Upstage White Tank Top
19844 FOR TODAY IMMORTAL RED
19867 BREATHE CAROLINA Savages Album White T-Shirt
19881 TEXAS IN JULY Brain Black
19883 WITHIN THE RUINS Green Crest Black Tank Top
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
21115 ISSUES Too Many Moons Heather Tank Top
21118 WE CAME AS ROMANS Horse & Rider All-Over-Print
21123 ATTILA Rage Tomahawk Royal Blue
21124 ATTILA Dirty Black
21125 BEARTOOTH Generation Of Disorder Black
21220 ATTILA RageAholics Red - T-Shirt
22586 I THE BREATHER SERCH FOR A BETTER LIFE
22588 WATCHOUT! THERES GHOSTS MONSTER TEE
22703 5 SECONDS OF SUMMER Jet Black Heart Tee
24541 ATTILA Fuck Your Shit Camo Black - T-Shirt
24655 NECK DEEP Hero Quest Black - Crewneck
24662 ISSUES I Have Issues Black - T-Shirt
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
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
24700 MEMPHIS MAY FIRE Logo Two Tone - TankTop
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
24704 MEMPHIS MAY FIRE Smokey Black - T-Shirt
24740 MEMPHIS MAY FIRE Shield Royal Blue - T-Shirt
24741 MEMPHIS MAY FIRE Challenger Red - T-Shirt
24748 WHITECHAPEL Pyro Black - T-Shirt
24755 WHITECHAPEL Crate Black - T-Shirt
24756 WHITECHAPEL Sawblade Maroon on Charcoal - T-Shirt
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
24758 WHITECHAPEL Sawblade Camo on Black - T-Shirt
24762 NORTHLANE Glitch Navy - T-Shirt
24768 NORTHLANE All-Over Print Black - T-Shirt
24771 NORTHLANE Gravity Black - Long Sleeve Shirt
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
24892 NORTHLANE Terence White - T-Shirt
25009 THE STORY SO FAR Snake Girl White - T-Shirt
25127 THE STORY SO FAR Snakes Black - T-Shirt
25132 SEAWAY Colour Blind Logo Black - T-Shirt
25134 SEAWAY Colour Blind TV Logo Yellow - T-Shirt
25135 SEAWAY Colour Blind Logo Grey - Pullover
25137 SEAWAY Crystal Ball Black - T-Shirt
25144 CITY LIGHTS Arrows Black - Crewneck Sweatshirt
25148 WE CAME AS ROMANS Slytherin' Carcoal - T-Shirt
25158 WE CAME AS ROMANS TROY White - T-Shirt
25161 WE CAME AS ROMANS Cracked Hope Heather Grey - Crewneck
25162 WE CAME AS ROMANS Bombs White
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
25166 WE CAME AS ROMANS Conquer Maroon - T-Shirt
25188 IWRESTLEDABEARONCE W Paw Black - Long Sleeve Shirt
25193 IWRESTLEDABEARONCE Witch Black - T-Shirt
25227 MISS FORTUNE Leader Black - T-Shirt
25228 LIKE MOTHS TO FLAMES TDTWLF Torch Black - Long Sleeve
25230 LIKE MOTHS TO FLAMES Pizza Black - T-Shirt
25231 LIKE MOTHS TO FLAMES Devil Tie Dye
25232 LIKE MOTHS TO FLAMES Baseball Black - T-Shirt
25234 CHUNK!NO,CAPTAIN CHUNK! City Night White - TankTop
25248 CAPTURE THE CROWN Banners Red - T-Shirt
25257 CAPTURE THE CROWN We Are All Royalty Black - T-Shirt
25262 A SKYLIT DRIVE Soldier Black - Long Sleeve Shirt
25264 A SKYLIT DRIVE Hangin' So Loose White - T-Shirt
25302 BEFORE THEIR EYES Cross Black - T-Shirt
25307 CHIODOS This is Love CRAIG Black - T-Shirt
25308 CHIODOS Snowman Black - T-Shirt
25313 EMAROSA Side Fox Tr-Blend Heather Grey - TankTop
25409 FINCH Flame Blue/White - Baseball Shirt
25415 I SEE STARS Old Dude