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 =571
)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-05-22 18:45:11')
AND pc.classcategory_id1 IN( 12,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
40042 Zephyren BIG SHIRT S/S -Resolve- GEO WHITE
56557 Nine Microphones RAISED SHIRT S/S -The angel GREEN
56559 Nine Microphones WORK SHIRT S/S -Power of will- MU
8152 Subciety EMBLEM SHIRT S/S-Plain- WHITE
54076 RUDIE'S (ルーディーズ) TUSK OPEN COLLAR SHIRTS BLACK
25266 DOCAN! ANARCHY workshirt
36808 SLIPKNOT Logo on Front Pentagram Group on Back Black Button Down
54084 SUICIDAL TENDENCIES x MxMxM “MAGICAL TENDENCIES” WORK SHIRT BLACK
54085 SUICIDAL TENDENCIES x MxMxM “MAGICAL TENDENCIES” WORK SHIRT DOKU
54086 SUICIDAL TENDENCIES x MxMxM “MAGICAL TENDENCIES” WORK SHIRT BLUE
54195 MISHKA MSS200204F SHIRTS
54202 TOY MACHINE NEON PRINT SS SHIRT - WINE
54203 TOY MACHINE NEON PRINT SS SHIRT - BLACK
54204 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - BLACK
54434 ANIMALIA AN20U-SH04 BIG DOLMAN SHIRTS BLACK
54435 ANIMALIA AN20U-SH04 BIG DOLMAN SHIRTS OLIVE
54460 MISHKA(ミシカ) MSS200207 SHIRT
54553 MAGICAL MOSH MISFITS MxMxM TRUMP SHIRT DOKU
54554 MAGICAL MOSH MISFITS MxMxM TRUMP SHIRT WHITE
54562 SABBAT13 GHOST CHECK S/S SHIRTS BROWN
54563 SABBAT13 GHOST CHECK S/S SHIRTS BLUE
54564 SABBAT13 BORING SHIRTS BLACK
54565 SABBAT13 BORING SHIRTS MINT
54593 PARADOX PX17-SH01 REFLECTOR SHIRTS ECHO
54712 PUNK DRUNKERS [PDSxKUDAN]PUNKUDAN式 総柄ベアシャツ BLUE
54713 PUNK DRUNKERS [PDSxKUDAN]PUNKUDAN式 総柄ベアシャツ GREEN
54552 MAGICAL MOSH MISFITS MxMxM どろどろシャツ PINK
54551 MAGICAL MOSH MISFITS MxMxM どろどろシャツ DOKU
54746 Dezzn Balabala Shirt
54747 Dezzn Savior Shirt BLACK
54077 RUDIE'S TUSK OPEN COLLAR SHIRTS WHITE
39582 Subciety MULTI CAMO SHIRT S/S
24966 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- OD
24964 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- WHITE
24963 Subciety (サブサエティ) EMBLEM SHIRT S/S-CAMOUFLAGE- BEIGE
24962 Subciety (サブサエティ) EMBLEM SHIRT S/S-CAMOUFLAGE- GREEN
23022 Subciety OMBRE CHECK SHIRT S/S-THRON- RED
23021 Subciety OMBRE CHECK SHIRT S/S-THRON- MUSTARD
23014 Subciety EMBLEM WORK SHIRT S/S-CHAMBRAY- BLUE
23004 Subciety ALOHA SHIRT S/S NAVY
22968 Subciety EMBLEM SHIRT S/S PINK
22967 Subciety EMBLEM SHIRT S/S YELLOW
54592 PARADOX PX17-SH01 REFLECTOR SHIRTS BLACK
16882 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - BLACK
53213 Zephyren(ゼファレン)LONG SHIRT S/S BLACK / pagan
53234 Zephyren(ゼファレン)SWITCHING SHIRT S/S MIX
53256 Zephyren(ゼファレン)PHOTO PRINT SHIRT S/S BLACK / PAISLEY
53254 Zephyren(ゼファレン)PHOTO PRINT SHIRT S/S WHITE
53266 Zephyren(ゼファレン)BIG SHIRT S/S BROWN / WAGARA
54717 PUNK DRUNKERS 2FACE開衿シャツ BLUE
54716 PUNK DRUNKERS 2FACE開衿シャツ BLACK
55648 THRASHER (スラッシャー) TH5179 S/S WORK SHIRT WHITE
55647 THRASHER TH5178 SKATE AND DESTROY S/S Shirt BLACK
55649 THRASHER TH5179 S/S WORK SHIRT BLACK
54767 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS BLACK
54765 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS RED
54766 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS SAX
57072 SLIGHTLY NUMB SAPPY ALOHA SHIRT
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
56066 Subciety 2021 福袋 -NEW YEAR BAG-
57367 MISHKA M21000205 S/S Shirt
56435 Subciety CHILL SHIRT- MUSTARD
58372 WASTED PARIS Shirt Apologies Black
58373 WASTED PARIS Shirt Mazzy Black
58491 RUDIE'S SPARK OPENCOLLAR SHIRTS BLACK
57439 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BURGUNDY
57444 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK / You are hare
57926 Subciety OPEN COLLAR SHIRT- SILVER
57927 Subciety OPEN COLLAR SHIRT- BLACK
58546 SABBAT13 13TALED FOX ALOHA SHIRTS ブラック
58728 VIRGO VGW ALOHA SHIRTS BLACK
58779 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
58786 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
59221 LONELY論理 LONELISM SHIRTS black
59220 LONELY論理 LONELISM SHIRTS white
59226 ROLLING CRADLE TV STATIC SHIRT BLACK
56433 Subciety CHILL SHIRT- BLACK
59246 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLACK
59247 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLUE
57458 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - FLOWER
57451 Zephyren(ゼファレン) SHIRT S/S - Resolve - FLOWER
57461 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - WHITE
57443 Zephyren(ゼファレン) EMBLEM SHIRT S/S WHITE / You are hare
57438 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BLACK
57437 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - WHITE
58580 MISHKA(ミシカ) M21000208 S/S Shirt
59869 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 YELLOW
59870 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 ORIVE
59871 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 GRAY
57463 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - BLACK / PAISLEY
58703 GoneR GR29SH001 Chambray Work Shirts
58171 PUNK DRUNKERS 豹シャツ - WHITE/BEIGE
58172 PUNK DRUNKERS 豹シャツ - BLACK/GRAY
57920 Subciety (サブサエティ) WEEKENDER SHIRT - BLACK
57921 Subciety (サブサエティ) WEEKENDER SHIRT - BEIGE
57922 Subciety (サブサエティ) HALF ZIP CUBA SHIRT- BLACK
58727 VIRGO VGW ALOHA SHIRTS RED
60158 Anti Social Social Club STATIC BLACK BUTTON UP
60159 Anti Social Social Club STATIC ORANGE BUTTON UP
60156 Anti Social Social Club WOODY WHITE BUTTON UP
61094 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BROWN
61095 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS KHAKI
61096 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BLACK
62566 NineMicrophones CRAZY SHIRT BLACK/WHITE
62567 NineMicrophones CRAZY SHIRT MULTI
62647 【予約商品】PUNK DRUNKERS ホラーアロハシャツ - WHITE
61925 glamb (グラム) Nixon Aloha SH - Black
16880 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - WHITE
57457 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - PAISLEY
57455 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - NAVY CHECK
57453 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - WHITE CHECK
57456 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - RED CHECK
62209 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK CHECK
62208 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK / PAISLEY
63449 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS WHITE
63450 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS BLUE
63451 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS GREEN
57442 Zephyren(ゼファレン) EMBLEM SHIRT S/S MIX
62195 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK