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 (
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-24 16:26:40')
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 240, 120
15466 CHIODOS Chaos White T-Shirt
15467 CHIODOS This Is Love Band - T-Shirt
15471 CROWN THE EMPIRE Axe Navy
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
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
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
18983 WE CAME AS ROMANS Wont Fade Away Navy
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
19093 ATTILA South By Suck My Fuck Black
19095 ATTILA Biker Black T-Shirt
19096 ATTILA Bad Reputation Black
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
19844 FOR TODAY IMMORTAL RED
19867 BREATHE CAROLINA Savages Album White T-Shirt
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
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
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
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
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
25137 SEAWAY Crystal Ball Black - T-Shirt
25148 WE CAME AS ROMANS Slytherin' Carcoal - T-Shirt
25158 WE CAME AS ROMANS TROY White - T-Shirt
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
25193 IWRESTLEDABEARONCE Witch Black - T-Shirt
25227 MISS FORTUNE Leader Black - T-Shirt
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
25248 CAPTURE THE CROWN Banners Red - T-Shirt
25257 CAPTURE THE CROWN We Are All Royalty Black - T-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
25415 I SEE STARS Old Dude
25443 MAYDAY PARADE Dying To Meet You Black - T-Shirt
25450 MAYDAY PARADE Bright Idea
25482 PIERCE THE VEIL Orange Seal Black - T-Shirt
25487 SECRETS Scuba Black - T-Shirt
25488 SECRETS Flag White - T-Shirt
25491 THE SUMMER SET Legendary Black - T-Shirt
25492 THE SUMMER SET Perfectly Wasted Youth White - T-Shirt
25508 WHITECHAPEL Memorial Black - Girl Shirt
26142 CONVERGE Poacher Black
26150 I KILLED THE PROM QUEEN Monogram Tee
26451 MOTION CITY SOUNDTRACK GO Album Logo
26454 REFUSED All Dressed Up
26455 SLEEPING WITH SIRENS Red Chain
26456 SLEEPING WITH SIRENS Grey Crest
27374 THE USED VULNERABLE T
27794 LANDON TEWERS The Captain Black
28020 MYKA RELOCATE MYK-T01 TEE
28025 ATTILA BASEBALL T-SHIRT
28026 ATTILA A T-Shirt
28240 CITY LIGHTS Skeleton T-shirt
28295 THE BROWNING Skull Black
28301 UPON A BURNING BODY Logo All Over T-Shirt
28569 EXODUS HORNED SKUL
28607 PINK FLOYD MELTING PRISM
28609 PINK FLOYD COMPASS
28627 GUNS N' ROSES HEADS VINTAGE
28641 AMON AMARTH WOLFORD