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 19:18:22')
AND pc.point_rate >1
AND FIND_IN_SET(14, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
64934 MISHKA (ミシカ) M21100902 SHORTS
64932 MISHKA (ミシカ) M21100908 SHORTS
64933 MISHKA (ミシカ) M21100527 JACKET
61777 MISHKA (ミシカ) M21100512 JACKET
58746 MISHKA NEW WORLD ORDER TEE BLUE
64123 SLEEPING TABLET(スリーピング・タブレット) CRIME [ FLEECE LINING SIDE ZIP PANTS ] BLUE
57795 SALUTE EVAE* X BLACKLUX NECKLACE
64125 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ PULLOVER ] BLUE
64138 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ BEANIE ] SAX
63594 glamb (グラム) Heavy Damaged SH - Blue
64975 ROLLING CRADLE RC x KUDAN LOGO SOX / BLUE
64897 kirou school (キロウスクール) krs_010 KRSC T-shirts STONE BLUE
64864 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE LIGHT BLUE
64318 Subciety (サブサエティ) FLOCKS CAP NAVY
63813 Subciety(サブサエティ) PAISLEY COACH SHIRT BLUE
63383 Anti Social Social Club Out Of Time Blue Tee
63388 Anti Social Social Club Down The Tube Blue/White Socks
64074 AFFECTER (アフェクター) TAG Tee BLUE
63423 ZENON(ゼノン) Front logo striped shirt BLUE
63581 glamb (グラム) Pullover Line Jersey - Blue
63884 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / YELLOW
63347 ROLLING CRADLE (ローリングクレイドル) HI-NECK SWEAT TEE / NAVY
63345 ROLLING CRADLE (ローリングクレイドル) BIG CHECK SHIRT / NAVY
63816 ROLLING CRADLE (ローリングクレイドル) VVV TEE / BLUE
63121 HEDWiNG (ヘドウィグ) Back to laughter Tie-dye T-shirt Navy
62532 TOY MACHINE (トイマシーン) BLOOD SUCKING COVERALL JACKET - ONE WASH
63445 BAD BOY (バッドボーイ) RAINBOW EMBROIDERY TEE L.BLUE
63448 BAD BOY (バッドボーイ) FIREPATTERN LOGO PRINT Tee L.BLUE
62114 ROLLING CRADLE SKAJAN JERSEY / BLUE
63328 Meltyglow (メルティグロウ) 総柄半袖PARKA【Fall melty】
62909 PSYCHOLOGICAL METAMORPHOSIS CG SWEAT PANTS - BLUE
63066 ANIMALIA AN22SP-SW07 DOUBLE KNIT HOODIE-Overlap Logo BLUE
61494 glamb (グラム) Old School Jersey Pants BLUE
62567 NineMicrophones CRAZY SHIRT MULTI
61855 A FEW GOOD KIDS ICECREAM TEE BLUE
61442 glamb (グラム)×攻殻機動隊 SAC_2045 sweat Blue
61071 VIRGO COSMIC FLOWER 2FACE JKT L.GRY/AQUA
61059 NieR (ニーア) logo LONGSLEEVE CUTSEW
59336 SLEEPING TABLET GENE [ RAW DENIM TRUCKER JACKET ] INDIGO
59440 Zephyren(ゼファレン) DENIM JKT - Victoria - INDIGO / BLACK
58979 Subciety (サブサエティ) STRIPE OVER SHIRT - BLUE
60645 RIPNDIP Marker Slip On Shoes
60334 LONELY論理 COTTON DAMAGED CLASSIC LOGO CAP M.BLUE
60128 HYPER CORE HTC-372 ぴえんICE BEAR Tシャツ L.BLUE
58698 GoneR GR29CT002 Square Mexican Skull T-Shirts Stone Blue
58414 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA SAX-ORG
59844 HYPER CORE T-367 承認欲求がぁる2 -I need your Reply, Retweet & いいね- Tシャツ ブルー×パープル
59422 SUPPLIER (サプライヤー) GRADATION KNIT BLUE&YELLOW
59423 SUPPLIER (サプライヤー) GRADATION KNIT PINK&BLUE
58595 SLEEPING TABLET REVERIE [ PATTERNED PAJAMA PANTS ] NAVY
58605 SLEEPING TABLET NOBLE [ SILKY PAJAMA PANTS ] LAVENDER
56122 N.B.O. BLUE FLARED DENIM PANTS
57818 四星球×ゲキクロ 限定コラボ・パーカー ライトブルー
58511 ANIMALIA AN21S-KN01 TEANA KNIT NAVY
58328 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO L.BLUE
58327 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO INDIGO
58044 ROLLING CRADLE RIP-STOP JACKET BLUE
57806 ROLLING CRADLE RCxHigh-Me TOKYO "PIERCE -HEART-" / A-TYPE
57807 ROLLING CRADLE RCxHigh-Me TOKYO "PIERCE -HEART-" / B-TYPE
57808 ROLLING CRADLE RCxHigh-Me TOKYO "EARRING -HEART-" / A-TYPE