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 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-05-23 16:00:44')
AND pc.classcategory_id1 IN( 14,61,35)
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 540, 180
19013 CHELSEA GRIN Skull Bind Black T-Shirt
19014 REVOCATION Deathless Album Black
19015 REVOCATION Madness Opus Black
19016 REVOCATION Madness Opus White
19017 REVOCATION Hive Black
19018 UPON A BURNING BODY Rattlesnake Black
19019 WHITECHAPEL Bloody Blade Black
19092 ATTILA A LOGO CAMO
19093 ATTILA South By Suck My Fuck Black
19094 ATTILA About That Life Graffiti Red
19095 ATTILA Biker Black T-Shirt
19096 ATTILA Bad Reputation Black
19100 ATTILA Guilty Pleasure Black Crewneck
19102 ATTILA Guilty Pleasure Black T-Shirt
19104 ATTILA RAGEAHOLICS WHITE
19106 ATTILA REAPER BLACK/HEATHER TANK TOP
19108 ATTILA WEEEED WHITE
19126 MOTIONLESS IN WHITE Mirror Girl Black
19127 MOTIONLESS IN WHITE Logo Black On Dark Heather
19131 SLEEPING WITH SIRENS Radio Black Tank Top
19132 SLEEPING WITH SIRENS Radio Black
19133 SLEEPING WITH SIRENS Feather Charcoal Grey T-Shirt
19134 SLEEPING WITH SIRENS Tough As Nails Silver T-Shirt
19156 a crowd of rebellion Blood Sphere Ver2 WHITE
19157 a crowd of rebellion Blood Sphere Ver2 BLACK
19158 a crowd of rebellion 【お犬様】
19800 CHUNK!NO,CAPTAIN CHUNK! Steering Wheel Cardinal Re
19801 CHUNK!NO,CAPTAIN CHUNK! Gray Text
19805 CAPTURE THE CROWN Coat Of Arms Black
19808 CAPTURE THE CROWN Grim Concrete/Cherry
19810 CAPTURE THE CROWN Leopard
19812 CAPTURE THE CROWN Reign Of Terror Album
19813 CAPTURE THE CROWN Skull King
19821 MAYDAY PARADE Label Crimson Tie Dye
19822 MAYDAY PARADE Mistakes Navy
19832 TONIGHT ALIVE The Other Side Black/White Baseball
19833 REAL FRIENDS Maybe This Place is the same
19835 THE SUMMER SET Floral Triangle Teal
19836 MAYDAY PARADE Upstage White Tank Top
19839 THE DEVIL WEARS PRADA Splatter BLACK
19840 ASKING ALEXANDRIA APPETITE FOR SIN
19844 FOR TODAY IMMORTAL RED
19846 FOR THE FALLEN DREAMS Stand Up Black
19847 FOR THE FALLEN DREAMS Heavy Hearts Hoodie
19855 OF MICE & MEN Text Heather Athletic Grey Hooded S.
19856 A SKYLIT DRIVE Rise Again Maroon
19857 A SKYLIT DRIVE Rise Again Camo
19858 A SKYLIT DRIVE Grim Reaper
19859 A SKYLIT DRIVE Skyfall Heather Grey T-Shirt
19860 A SKYLIT DRIVE Ascension Circle White T-Shirt
19870 CROWN THE EMPIRE Oh, Catastrophe Heather Grey Tee
19872 EMAROSA Versus Black
19874 WE CAME AS ROMANS Wolf Black ZIP Hoodie
19875 DANCE GAVIN DANCE Eye Black
19876 DANCE GAVIN DANCE Zoo White
19879 PROTEST THE HERO Trek Hand Dark Heather Grey Tee
19880 TEXAS IN JULY Awake White T-Shirt
19881 TEXAS IN JULY Brain Black
19882 TEXAS IN JULY Voodoo 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
20028 METALLICA GREEN DEMON TEE
20033 GUNS N' ROSES ROSES AND SKULL TEE
20216 【激ロック限定デザイン】NINJA KORE THE NINJA
20217 【激ロック限定デザイン】NINJA KORE MR.BOMB
20340 SUICIDAL TENDENCIES JERSEY SHORTS
20341 SUICIDAL TENDENCIES YOU CANT BRING ME DOWN TEE
20523 5 SECONDS OF SUMMER Sounds Good Feels Good TEE
20550 PALISADES Pyramid Black
20551 PALISADES NXTLVL Black Basketball
20552 PALISADES Future Music Black Tank Top
20553 PALISADES Wolves...TS Black
20558 PALISADES Logo White Tank Top
20559 PALISADES Mind Games Black Jersey
20560 PALISADES Kanji Black T-Shirt
21114 ISSUES Diamond Eyes Black
21115 ISSUES Too Many Moons Heather Tank Top
21116 ISSUES Many Moons Ago Heather Athletic Gray T-Shir
21117 ISSUES Black Diamonds Black
21118 WE CAME AS ROMANS Horse & Rider All-Over-Print
21121 ATTILA Rebel Black
21123 ATTILA Rage Tomahawk Royal Blue
21124 ATTILA Dirty Black
21125 BEARTOOTH Generation Of Disorder Black
21126 AUGUST BURNS RED Shapes Black - T-Shirt
21127 DANCE GAVIN DANCE Deathstar Black
21197 ATTILA Rageaholics T-shirt Black
21220 ATTILA RageAholics Red - T-Shirt
22586 I THE BREATHER SERCH FOR A BETTER LIFE
22703 5 SECONDS OF SUMMER Jet Black Heart Tee
22704 5 SECONDS OF SUMMER Crown Pocket Tee
24537 ATTILA Bandana Black - T-Shirt
24539 ATTILA Damage White - T-Shirt
24540 ATTILA Original Villains Black - T-Shirt
24541 ATTILA Fuck Your Shit Camo Black - T-Shirt
24550 ATTILA Neighborhood White - T-Shirt
24552 BLESS THE FALL Skull Snake Heather Gray
24553 BLESS THE FALL To Those Left Behind Black
24554 BLESS THE FALL Cross Swords Black - Sleeveless Shirt
24556 PROTEST THE HERO Octo Tree Snow Military
24557 PROTEST THE HERO Yellow Teeth White/Black - TankTop
24558 PROTEST THE HERO Knee Face Silver - T-Shirt
24640 NECK DEEP Flag Black
24641 NECK DEEP Skulls Black T-Shirt
24642 NECK DEEP Skulls Black - Crewneck
24644 NECK DEEP Shooting Eye Black - T-Shirt
24645 NECK DEEP Flag BlackShooting Eye Black - Pullover
24646 NECK DEEP Generic Pop Punk Athletic Heather
24647 NECK DEEP Tiger Black - T-Shirt
24652 PROTEST THE HERO Keys White/Navy - Baseball Tee
24653 PROTEST THE HERO Underbite Dark Heather T-Shirts
24654 PROTEST THE HERO Sparrow Navy - T-Shirt
24655 NECK DEEP Hero Quest Black - Crewneck
24656 GET SCARED Demon Clock Black - T-Shirt
24657 GET SCARED Demon Coffin Grey - T-Shirt
24661 ISSUES S/T Album Art Black - T-Shirt
24662 ISSUES I Have Issues Black - T-Shirt
24663 ISSUES The Road Black - T-Shirt
24664 ISSUES Black Diamonds Heather Grey - T-Shirt
24665 ISSUES Hooligans White - T-Shirt
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
24669 SLEEPING WITH SIRENS Light & Death White
24670 SLEEPING WITH SIRENS Floral White - T-Shirt
24674 SLEEPING WITH SIRENS Tough As Nails Heather Grey - Crewneck
24676 SLEEPING WITH SIRENS Radio Black - Pullover
24677 SLEEPING WITH SIRENS If You Were A Movie.. Sublimation
24679 SLEEPING WITH SIRENS Sealed Lips Black - T-Shirt
24681 SLEEPING WITH SIRENS Guns White - T-Shirt
24683 TONIGHT ALIVE Floral Logo White - T-Shirt
24690 WOE IS ME Space Battle Black - T-Shirt
24698 MEMPHIS MAY FIRE Love Truth Long Sleeve White - T-Shirt
24699 MEMPHIS MAY FIRE Battleground Black
24700 MEMPHIS MAY FIRE Logo Two Tone - TankTop
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
24703 MEMPHIS MAY FIRE Don't Hold The Key Black - T-Shirt
24704 MEMPHIS MAY FIRE Smokey Black - T-Shirt
24705 MEMPHIS MAY FIRE Fight Fight Fight White - T-Shirt
24706 MEMPHIS MAY FIRE Shark White - T-Shirt
24736 MEMPHIS MAY FIRE Logo Maroon - Zip Up
24737 MEMPHIS MAY FIRE On Our Own Black - T-Shirt
24738 MEMPHIS MAY FIRE Speaking Out White
24739 MEMPHIS MAY FIRE Bear White - T-Shirt
24740 MEMPHIS MAY FIRE Shield Royal Blue - T-Shirt
24741 MEMPHIS MAY FIRE Challenger Red - T-Shirt
24742 MEMPHIS MAY FIRE Logo White - T-Shirt
24745 WHITECHAPEL Sell Your Soul Black - T-Shirt
24747 WHITECHAPEL Bleeder White - T-Shirt
24748 WHITECHAPEL Pyro Black - T-Shirt
24749 WHITECHAPEL Sacrifice Black/White - Baseball T-Shirt
24750 WHITECHAPEL Demon Wolf Black - Long Sleeve Shirt
24752 WHITECHAPEL Invaders Black T-Shirts
24753 WHITECHAPEL Adrenaline White - T-Shirt
24754 WHITECHAPEL Crate Black - Pullover
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
24759 WHITECHAPEL Hypocrisy Heather Gray - Zip-Up Sweatshirt
24761 NORTHLANE Sphere Black w/ Orange Spider Tie Dye - T-Shirt
24762 NORTHLANE Glitch Navy - T-Shirt
24763 NORTHLANE One Small Step White - T-Shirt
24764 NORTHLANE Sphere Black - T-Shirt
24765 NORTHLANE Daydreamer Black - T-Shirt
24766 NORTHLANE Daydreamer White - T-Shirt
24767 NORTHLANE Free Your Mind Charcoal - T-Shirt
24768 NORTHLANE All-Over Print Black - T-Shirt
24769 NORTHLANE Obelisk Moth White - T-Shirt
24770 NORTHLANE Prism White - Long Sleeve Shirt
24771 NORTHLANE Gravity Black - Long Sleeve Shirt
24772 NORTHLANE RA Black - T-Shirt
24773 NORTHLANE Geometric White - T-Shirt
24774 NORTHLANE Omni Black - T-Shirt
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
24776 NORTHLANE Connected Tri-Charcoal - T-Shirt
24777 NORTHLANE Octogram Black - T-Shirt
24778 NORTHLANE Skyline White - T-Shirt
24779 NORTHLANE Rot Cover Dark Heather - T-Shirt
24780 NORTHLANE Bars Heather Grey - T-Shirt
24781 NORTHLANE Yin Yang Natural - T-Shirt