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 =17
)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 04:26:28')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL
56843 FAMOUS STARS AND STRAPS Fam Grown FF GRAY
52952 Survive Said The Prophet FIRE LOGO CAP
2444 NineMicrophones MESH CAP Deck-9- BLACK
3752 Subciety MESH CAP -BABYLON- BLKxGLD/OAK
4559 RUDIE'S SPARK MESH CAP BLACK/BLACK/BLUE
4560 RUDIE'S SPARK MESH CAP BLACK/BLACK/RED
6225 Subciety MESH CAP -GLORIOUS- NAVY
6229 Subciety MESH CAP -GLORIOUS- BLK/GLD
6252 MISHKA (ミシカ) KEEP WATCH OR DIE NEW ERA GREY
6975 MISHKA (ミシカ) K.W. DESTROY! PAINTERS CAP BLACK
7173 RUDIE'S NEO PUNK SNAPBACK CAP ORANGE/BLACK/YELLOW
7393 DROP DEAD CLOTHING CROSSING THE LINES FITTED HAT
7812 MISHKA (ミシカ) CYRILLIC SCRIPT NEW ERA GREEN
7934 VANS APPAREL Classic Patch Hat Wht/Blk
8330 SPITFIRE BIGHEAD Trucker Hat Black/White
9035 RUDIE'S BOUNDER CAMO JET CAP BEIGE CAMO
9226 Subciety B.B.CAP -GLORIOUS- BLACK/GOLD
9231 Subciety MESH CAP -OMG- BLACK/WHITE
9234 Subciety MESH CAP -OMG- DARK GREEN
9235 Nine Microphones MESH CAP -Power of will- D.GREEN
9333 MISHKA (ミシカ) NEW ERA: OVERSIZE ADDER DARK GREEN
9335 MISHKA (ミシカ) NEW ERA: LAMOUR KEEP WATCH MAGENTA
9336 MISHKA (ミシカ) NEW ERA: KEEP WATCH ORANGE
9339 SANTA CRUZ CLASSIC DOT FLEXFIT FITTED STRETCH BLK
9340 SANTA CRUZ CLASSIC DOT FLEXFIT FITTED STRETCH B/G
9342 SANTA CRUZ OTHER DOT TRUCKER MESH WHITE/BLACK
9343 SANTA CRUZ OPUS TRUCKER MESH HAT WHT/BLK
9346 SANTA CRUZ SC Block 2 Flex Fit Hat BLK
9615 SPITFIRE TIE DYE BIGHEAD FOAM TRUCKER HAT PUR/BLU
9616 SPITFIRE TIE DYE BIGHEAD FOAM TRUCKER HAT RED/ORA
9617 SPITFIRE FIREHEAD TRUCKER HAT RED
9857 DEADHEARTZ LOGO BACKET HAT
10035 MISHKA (ミシカ) NEW ERA: ARMY OF DARKNESS BLACK
10222 THRASHER TIGER STRIPE SNAPBACK CAP
10301 LUCKY13 RUN WHAT YA BRUNG CAP
10452 SPITFIRE Flaghead Trucker CAP WHT
10453 SPITFIRE Flaghead Trucker CAP BLK
10476 SUICIDAL TENDENCIES x INFECTIOUS GROOVES MESH CAP
10477 SUICIDAL TENDENCIES MESH CAP SKATES WHITE
10596 MISHKA (ミシカ) KEEP WATCH NEW ERA NAVY 2014SP
10597 MISHKA (ミシカ) KEEP WATCH NEW ERA BLACK 2014SP
10600 MISHKA (ミシカ) OVER SIZED DEATH ADDER NEW ERA NAVY 2014SP
10601 MISHKA (ミシカ) OVER SIZED DEATH ADDER NEW ERA BLACK 2014SP
10688 PUNK DRUNKERS B.B.CAP RED/BLACK
10946 FAMOUS STARS AND STRAPS FAMILY SMOKED Stretch CAP
10947 FAMOUS STARS AND STRAPS OG BOH CAP CAMO/RED
10948 FAMOUS STARS AND STRAPS OG BOH CAP CAMO/BLK
11099 MISHKA (ミシカ) DART NE CYCLE CAP WHITE
11110 REBEL8 STANDARD ISSUE LOGO NEW ERA
11117 REBEL8 STANDARD ISSUE LOGO SNAPBACK
11639 SQUARE MONSTER B.B CAP BLACK/BLUE
11641 SQUARE MONSTER B.B CAP BLACK/LIME
11642 SQUARE MONSTER B.B CAP BLACK/BLACK
11649 RUDIE'S MILLION SNAPBACK CAP BLUE/BLUE/ORANGE
11688 アマツカミ さよなら snapback WHITE
11689 アマツカミ うそつき snapback BLACK
12141 Subciety B.B.CAP -SALOON BLACK/BGN
12193 RUDIE'S × 梅村妃奈子 COLLABORATION SNAPBACK CAP BLK
12228 MISHKA (ミシカ) KILL WITH POWER NE 5950 RED
12230 MISHKA (ミシカ) STEAL YOUR SOUL TIE DYE SNAPBACK RAINBOW
12240 MISHKA (ミシカ) BEAST OF THE EAST NE 5950 BLUE DENIM
12243 MISHKA (ミシカ) BEAST OF THE EAST NE 5950 BLACK DENIM
12250 MISHKA (ミシカ) OVERSIZED RASTA ADDER NE 5950 BLACK
12251 MISHKA (ミシカ) OVERSIZED RASTA ADDER NE 5950 DARK GREEN
12259 MISHKA (ミシカ) DESTROY WORLD WIDESNAPBACK BLACK
12330 MISHKA (ミシカ) KEEP WATCH NE 5950 PURPLE
12692 Subciety × 7UNION B.B.CAP -SALOON-BLACK/RED
12832 FAMOUS STARS AND STRAPS PSYCHO BOH Stretch Fit Hat
12836 FAMOUS STARS AND STRAPS Black Psycho Fam FF Cap
12837 FAMOUS STARS AND STRAPS WRECKING BADGE L.BLUE
12857 FAMOUS STARS AND STRAPS Twitch Bolt Proof Cap BLK
12934 FAMOUS STARS AND STRAPS LOYALTY RESPECT CHAR/TEAL
13184 VANS APPAREL OFF THE WALL BREWED TRUCKER WHITE
13185 VANS APPAREL JASPAR CAMPER BLACK
13217 RUDIE'S DIG SNAPBACK CAP RED/RED/YELLOW
13282 RUDIE'S SWAG SNAPBACK CAP RED/GRAY/NAVY
13478 MISHKA (ミシカ) DEATH ADDER TIE DYE NEW ERA PURPLE
13487 MISHKA (ミシカ) KIRBY CAMO 5-PANEL CAMO
13742 REBEL8 SCHOLARS SNAPBACK
13745 REBEL8 S.I. LOGO W UNDERBRIM SNAPBACK BLACK
14093 FAMOUS STARS AND STRAPS LUDAKRIS Mens Stretch
14302 MISHKA (ミシカ) ALIEN DEATH CAP
14305 MISHKA (ミシカ) DEATH ADDER NEW ERA BURGUNDY
14306 MISHKA (ミシカ) DEATH ADDER NEW ERA BLACK
14490 BEFORE MY LIFE FAILS Bucket Hat Black
14492 BEFORE MY LIFE FAILS Bucket Hat White
14494 BEFORE MY LIFE FAILS 5panel cap
14554 RUDIE'S SPARK MESH CAP BLACK/BLACK/GREEN
14555 RUDIE'S SPARK MESH CAP BLACK/BLACK/PINK
14605 SLIPKNOT ALLOVERSTAR FLAT BRIM HAT
14606 SLIPKNOT STAR PATTERN BASEBALL HATS
14695 RUDIE'S SPARK SNAPBACKCAP BLACK/BLACK/BROWNLEOPARD
14714 Subciety MESH CAP -BABYLON- BLACK/GOLD
14775 MISHKA (ミシカ) BOOTLEG HORNS SNAPBACK BLACK
14941 FAMOUS STARS AND STRAPS Tastemaker Snapback
14998 RUDIE'S PASTE SNAPBACK CAP BLACK/BLACK/WHITE
15247 ZEPHYREN (ゼファレン) SNAPBACK CAP -BEYOND- BLK/BLK
15250 ZEPHYREN (ゼファレン) SNAPBACK CAP -Thorns fame- BLK
15255 ZEPHYREN (ゼファレン) MESH CAP -Thorns fame- BLK
15302 REBEL8 VNDERGROVND SNAPBACK
15340 WHITECHAPEL Sawblade Black Snapback Hat
15362 TONIGHT ALIVE 13 Navy Red Snapback
15419 DEADHEARTZ GOTHIC SNAPBACK /BLACK x FLORAL
15487 ATTILA Crosses Logo Black Snapback Hat
15488 PROTEST THE HERO Stacked Script Logo gray cap
15534 MAYDAY PARADE Arrow Black / Red Snapback
15541 RIP DESIGN WORXX スナップバックキャップ WHT
15542 RIP DESIGN WORXX スナップバックキャップ BLK
15543 RIP DESIGN WORXX スナップバックキャップ emerald
15881 THRASHER x GHOSTBUSTERS GHOST SNAPBACK BLK/GRY
15882 THRASHER x GHOSTBUSTERS GHOST SNAPBACK BLK/AQA
15883 THRASHER x GHOSTBUSTERS LOGO SNAPBACK BLK/BLK
15884 THRASHER x GHOSTBUSTERS LOGO SNAPBACK BLK/GRY
15885 THRASHER x GHOSTBUSTERS LOGO SNAPBACK NAVY
15934 BLACK CRAFT Believe In Yourself - Snapback Hat
15935 BLACK CRAFT Unholy - Snapback Hat
15936 BLACK CRAFT One Nation No God - Snapback Hat
15997 NineMicrophones SNAP BACK CAP-9MC Crew- BLK/WHT
15998 NineMicrophones SNAP BACK CAP-9MC Crew- BLK/BUR