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 10:43:04')
AND FIND_IN_SET(14, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
53924 THRASHER THRASHER DAVID GONZALEZ T-SHIRTS BLUE
6502 MISHKA 3-DESTROY T-SHIRT TURQUOISE
7437 CHUNK!NO,CAPTAIN CHUNK! Bear Blue T-Shirt
11287 Nine Microphones BE ON STAGE S/S DENIM
11428 MISERY SIGNALS Rebirth Denim Blue
12213 ROLLING CRADLE BiG CYCLOPS-Dr.J- Blue
13035 FAMOUS STARS AND STRAPS MESSY FAMILY Tee BLUE
13163 BLACK HOLE BUNNY Tシャツ Galaxy Logo BLUE
17603 ICECREAM BALLERS T-SHIRT ROYAL
18030 四星球 シンプルロゴTシャツ Blue
18039 四星球 テヘペロTシャツ Blue
18062 【ゲキクロ限定カラー】 四星球 ドット絵Tシャツ BLUE
18969 MEMPHIS MAY FIRE Anchor Aqua
19835 THE SUMMER SET Floral Triangle Teal
20994 NineMicrophones 9MICS CREW S/S BLU-MUS
21130 BEFORE MY LIFE FAILS BMLFCULT Color Tee NVY/PUR
21206 Stay Sick Clothing Cloud 9 Custom T-Shirt
21574 aquarifa レイ Tシャツ ウィメンズ アクア
21803 MISHKA (ミシカ) Lamour’s 2 Headed Monster T-Shirt TIEDYE
21921 MISHKA (ミシカ) GLOW IN THE DARK KEEP WATCH TEE Celadon
23077 Subciety(サブサエティ) GLORIOUS S/S-BRIGHT- BLUE
23438 MISHKA (ミシカ) LAMOUR DEATH ADDER TEE Royal
23769 9mm Parabellum Bullet 9tee BLUE
23929 a flood of circle AFOC LOGO TEE BLUE
24030 ANIMALIA AN16U-TE13 LOGO-Paint TIE DYE L.BLUE
24155 グッドモーニングアメリカ 国旗Tシャツ(ブルー)
24159 グッドモーニングアメリカ アメコミTシャツ(ライトブルー)
24195 MISHKA (ミシカ) KEEP WATCH BOX LOGO TEE Pacific Blue
24257 UNDEAD CORPORATION 朱美デザインTシャツ Tie Dye
24304 キバオブアキバ POPKILLER コラボTシャツ
24596 ROLLING CRADLE SD ROLICLE Tee / Blue
24675 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) ISLAND DAZE BOH TURQUOISE
24740 MEMPHIS MAY FIRE Shield Royal Blue - T-Shirt
24812 RUDIE'S DECAY TIGER STRIPE DYED-T BLUE
24900 ANIMALIA DOWN TO TEXAS BLUE
24941 Zephyren (ゼファレン) S/S TEE -VISIONARY- BLUE
24942 Zephyren (ゼファレン) S/S TEE -BEYOND- BLUE
25022 REBEL8 STRIKE FIRST S/S TEE ROYAL
25065 Zephyren (ゼファレン) S/S TEE -REBEL FLAG- BLUE
25209 RIP DESIGN WORXX RIPDW STANDARD LOGO T-SHIRT Turquoise×Pink
25304 CROWN THE EMPIRE The Fallout Tie Dye - T-Shirt
25311 THE DEVIL WEARS PRADA All Over Print Blue
25503 ROLLING CRADLE RC OFFICIAL T / Blue-Red
25760 Subciety GLORIOUS S/S BLUE-WHITE
26215 RUDIE'S DISCHARGE SCREW DYED-T BLUE
26239 Zephyren (ゼファレン) S/S TEE -Zion- BLUE
26271 DESCENDENTS Van
26311 Zephyren (ゼファレン) TIE DYE S/S TEE -VISIONARY- NAVY
26313 Zephyren (ゼファレン) TIE DYE BIG S/S TEE -VISIONARY- NAVY
26399 【限定アイテム】モーモールルギャバン ロゴTシャツ(すしおデザイン)
26612 PUNK DRUNKERS 1つ目宇宙人TEE S.BLUE
26626 RUDIE'S NINEONE COLLEGE-T BLUE
27412 THRASHER MAGZINE LOGO T-SHRT BLUE
27496 Zephyren (ゼファレン) LONG S/S TEE -Ace of spades- Blue
27894 DISTURBIA CLOTHING (ディスタービア・クロージング) Nightmare Nightie
27940 RIP DESIGN WORXX SUMMER LOGO 2016 BLUE×SYRUP
28057 SPITFIRE Retro Classic T-Shirt - Royal Tie Dye
28085 RUDIE'S AGAINST SPARK-T BLUE
28100 PARADOX GRAPHIC BIG TEE HIDEOUT
28103 PARADOX GRAPHIC BIG TEE STELLA
28105 PARADOX GRAPHIC BIG TEE PUNK
28411 THRASHER TH9105 NECKFACE TEE SAPPHIRE
28498 PUNK DRUNKERS 【PDSx円谷プロ】セミ人間TEE LT.BLUE
28509 PUNK DRUNKERS 【PDSxキン肉マン】スプリングマンTEE TURQUOISE
28772 VIRGO W-MOUNTAIN SST NAVY
28814 RUDIE'S PHAT-T BLU
29567 Aldious LIVE 2016 Tシャツ ブラック x ブルー
29812 MISHKA GROTESQUE KEEP WATCH TEE CELADON
31525 NIRVANA KURT COBAIN BUS PHOTO TEE
32048 THRASHER DIAMOND EMBLEM S/S
32531 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) COMIC F Tee BLUE
32541 PARADOX BIG TEE VOID
33034 THRASHER TH8101 MAG LOGO TEE L.BLE
33196 Zephyren (ゼファレン) EKG TIE DYE S/S TEE -BEYOND- BLUE
33453 PUNK DRUNKERS (パンクドランカーズ) スモールベアーTEE SAX
33641 MISHKA (ミシカ) ICE CREAM TEE BLUE
33653 MISHKA (ミシカ) LAMOUR K.W TEE BLUE
33992 THE TEST グラフィックビッグTシャツ POWER
34041 MISHKA (ミシカ) EXSP1703OL TEE SEAFOAM
34055 MISHKA (ミシカ) MELTDOWN KEEP WATCH BLUE
34060 MISHKA TIE DYE SOFT CREAM KEEP WATCH TEE TURQUOISE
34341 RUDIE'S SOLID PHAT-T TURQUOISE BLUE
34345 a crowd of rebellion 10th Anniversary Tour 2017 T-Shirts Light Blue
34510 THRASHER TH8163 TEE MINT
34540 MUSIC SAVED MY LIFE (MSML) BIG-TEE L.BLUE
34934 Zephyren (ゼファレン) S/S TEE -THORN CROSS- BLUExYELLOW
35008 PUNK DRUNKERSギャーTEE LIGHT BLUE
35601 BRING ME THE HORIZON WOUND WITH BURN OUT FINISHING
36143 PUNK DRUNKERS 【PDSxカリスジムx rvddw】CHARIS HILTON.TEE - LT.BLUE
36209 SQUARE WAVE BORDER Ts BLUE
36420 PUNK DRUNKERS PDSxKNAVE あいつvsカタキTEE R.BLUE
36528 ROLLING CRADLE RCxSpongeBob -Bob&Patrick- Blue
36541 RED HOT CHILI PEPPERS -Kaleidoscope-Light Blue
36620 RIP DESIGN WORXX エレメントTシャツ EMERALD
36633 RIP DESIGN WORXX ショルダーラインTシャツ MINT
36773 BRING ME THE HORIZON Steel City on blue t-shirt
36866 THRASHER TH8101 MAG LOGO TEE SAX
36948 THRASHER TH91130 FLAME MAG LOGO S/S ROYAL/OPAL
37112 RUDIE'S HEAD GEAR BRILLIANT SNAPBACKCAP BL/BLK
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
37330 RIP DESIGN WORXX オートグラフロゴガーメントダイTシャツ BLUE/ORANGE
37332 RIP DESIGN WORXX オートグラフロゴガーメントダイTシャツ NAVY/BLACK RED
37336 RIP DESIGN WORXX スーパーロング丈ブディスTシャツ 染
38017 Subciety (サブサエティ) PIGMENT TEE-THE BASE- BLUE
38838 MISHKA (ミシカ) LAMOUR ON SIGHT T-SHIRT FL 171120 CELADON
39150 CROWN THE EMPIRE The Fallout Tie Dye - T-Shirt[B]
39396 ROLLING CRADLE RC×B&B Tee "TITTY TWISTER" LIGHT BLUE
39567 DEADHEARTZ PLANET / COSMO BIG TEES
39605 Subciety ASTRONAUT S/S BLUE
39904 SANTA CRUZ Gremlin Patrol Hand S/S T-Shirt Royal
39989 MISHKA (ミシカ) MSKBC-1T T-Shirt LT Blue
40662 MISHKA SP181309 WAR COMIC TEE LIGHT BLUE
40667 MISHKA SP181312 MAGICAL ARTS TEE LIGHT BLUE
40741 PUNK DRUNKERS 酔っ払って寝るTEE R.BLUE
40743 PUNK DRUNKERS DNA.TEE MINT
40897 RUDIE'S DRAWING BALL-T BLUE
41007 Subciety Beach S/S LIGHT BLUE
41220 REBEL8 Relegate Tee Blue
41329 MISHKA MSS180011 T-shirts BLUE
41347 MISHKA EX181342 KEEP IT CHILL TEE BLUE