SELECT SQL_CALC_FOUND_ROWS 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-03-29 02:56:32')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 517)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
27409 ANIMALIA (アニマリア) ラバーバンド
60425 ANIMALIA AN21A-CP03 BEANIE-LOGO GRAY
63198 ANIMALIA (アニマリア) Double Cutaway - logo WHITE
50365 ANIMALIA AN19M-AC02 ROPE-BELT BLACK
50366 ANIMALIA AN19M-AC02 ROPE-BELT RED
60423 ANIMALIA AN21A-CP05 BERET- Fleur De Lis BLACK
64924 ANIMALIA (アニマリア) TOWEL-LOGO
33842 ANIMALIA AN17U-TE08 FIGHT IT OUT WHITE
58060 ANIMALIA AN21S-TE03 Tokyo Disregard WHITE
37764 ANIMALIA AN17A-CP07 BEANIE #008 GRAY
51650 ANIMALIA AN19W-CP03 BOONIE BERET #005 BLACK
59118 ANIMALIA AN21U-TE11 FALLING BLACK
50362 ANIMALIA AN19M-CP03 CORDURA® BUCKET HAT-LOGO BLACK
51652 ANIMALIA AN19W-AC08 WOOL SCARF - LOGO GRAY
51653 ANIMALIA AN19W-AC08 WOOL SCARF - LOGO RED
64920 ANIMALIA (アニマリア) HEAD BAND BLACKxRED
22897 ANIMALIA 49ers SOX #002 NAVY
22898 ANIMALIA 49ers SOX #002 WHITE
53968 ANIMALIA AN20SP-AC01 MID SOX-Ealge BLACK
53969 ANIMALIA AN20SP-AC01 MID SOX-Ealge WHITE
60429 ANIMALIA AN21A-AC03 ZINC CROSS GOLD
31622 ANIMALIA AN17S-AC08 Huprok SOX #001 SAX
31624 ANIMALIA AN17S-AC08 Huprok SOX #001 WHITE
46755 ANIMALIA(アニマリア) AN19S-AC04 KNEE-HIGHS : LOGO BLACK
46756 ANIMALIA(アニマリア) AN19S-AC04 KNEE-HIGHS : LOGO WHITE
69614 ANIMALIA (アニマリア) SOX - A sign WHITE
69615 ANIMALIA (アニマリア) SOX - A sign BLACK
59123 ANIMALIA AN21U-PT03 VERSATILE SHORTS
56515 ANIMALIA AN20A-TE06 “SWAGGER CLOTHINGS Poster” L/S TEE WHITE
60738 ANIMALIA AN21A-CP04 FLIGHT CAP BLACK
61390 ANIMALIA ANKN-TE05 UKIYOE - Hurricane mixer L/S BLACK
61391 ANIMALIA ANKN-TE08 10M Powers L/S BLACK
64921 ANIMALIA (アニマリア) ANIMALIA COMFY SANDAL
24094 ANIMALIA ANIMAL-AC26 CONCHO #001 SILVER.BUFFALO
24095 ANIMALIA ANIMAL-AC26 CONCHO #001 SILVER.HATCHET
24109 ANIMALIA AN16S-AC09 WOOD SKIN Pencil Case NATURAL
24909 ANIMALIA WOOD SKIN Pencil Case
27693 ANIMALIA ANIMAL-AC26 CONCHO #001 SILVER.BUFFALO
27696 ANIMALIA ANIMAL-AC26 CONCHO #001 BRASS.HATCHET
59121 ANIMALIA AN21U-SH03 POLO SHIRTS BLACK
24116 ANIMALIA AN16U-AC05 TYVEK Pouch WHITE
65147 ANIMALIA AirPods Pro CASE - LOGO
65148 ANIMALIA AirPods CASE(第1、第2世代)
60431 ANIMALIA AN21A-AC04 ZINC GOOD LUCK HOOF GOLD
61524 ANIMALIA AN22SP-PT02 EASY PANTS - Sanskrit Logo BLACK
49229 ANIMALIA AN19U-CS01 SELVAGE-Oil Ticket BLACK
52897 ANIMALIA AN20SP-CP01 '49Cap-LOGO BLACK x EMERALD
66251 ANIMALIA(アニマリア) PU LEATHER BUCKET HAT BLACKxWHITE
24916 ANIMALIA 49in Coin Case
59119 ANIMALIA AN21U-TE10 DIVING WHITE
40451 ANIMALIA AN18U-AC19 FISHERMAN'S SANDALS BLACK
40452 ANIMALIA AN18U-AC19 FISHERMAN'S SANDALS RED
40453 ANIMALIA AN18U-AC19 FISHERMAN'S SANDALS WHITE
40454 ANIMALIA AN18U-AC19 FISHERMAN'S SANDALS YELLOW
68566 ANIMALIA (アニマリア) FANNY PACK BLACK
40447 ANIMALIA AN18U-PT05 TRACK SHORTS-Slashed BLACK
61514 ANIMALIA AN22SP-SH01 CHAMBRAY SHIRTS - A.C. Brand DENIMxWHITE
43051 ANIMALIA AN18A-AC03 Musette Bag #001 BLACK
43052 ANIMALIA AN18A-AC03 Musette Bag #001 WHITE
46757 ANIMALIA AN19S-AC07 MUSETTE BAG #002 BLACK
46758 ANIMALIA AN19S-AC07 MUSETTE BAG #002 NATURAL
55975 ANIMALIA AN20A-SW06 “BLACKFOOT” Big silhouette Crew Neck Sweat WHITE
58288 ANIMALIA AN21S-SW04 DREAM CATCHER P/O SWEAT
60735 ANIMALIA AN21A-PT01 COCKY PANTS BLACK
31627 ANIMALIA AN17S-AC13 ALUMINUM BOTTLE-300ml BLACK
31628 ANIMALIA AN17S-AC13 ALUMINUM BOTTLE-300ml WHITE
38575 ANIMALIA AN17A-AC02 SNOOD #003 MIX BLACK
60424 ANIMALIA AN21A-CP03 BEANIE-LOGO BLACK
60426 ANIMALIA AN21A-CP03 BEANIE-LOGO NAVY
24003 ANIMALIA AN16U-TE01 ANIMALIA/Disney special item/MICKEY MOUSE Tee INK BLK
63185 ANIMALIA (アニマリア) SLUB Tee S/S - logo BLACK
22900 ANIMALIA BEANIE #005 BLK
22901 ANIMALIA BEANIE #005 RED
22902 ANIMALIA BEANIE #005 GRAY
24060 ANIMALIA AN16S-CP08 BEANIE #006 BLACK
24061 ANIMALIA AN16S-CP08 BEANIE #006 KHAKI
24062 ANIMALIA AN16S-CP08 BEANIE #006 RED
37765 ANIMALIA AN17A-AC15 PARACORD Bracelet BLK
37766 ANIMALIA AN17A-AC15 PARACORD Bracelet OLIVE
39454 ANIMALIA AN18S-AC02 PVC POUCH BLACK
39455 ANIMALIA AN18S-AC02 PVC POUCH BEIGE
48255 ANIMALIA AN19U-AC01 METAL PENCIL BOX & 2 BALLPOINT PEN SET BLACK
48256 ANIMALIA AN19U-AC01 METAL PENCIL BOX & 2 BALLPOINT PEN SET RED
60427 ANIMALIA AN21A-AC01 CROSS KIHEI Bracelet : WIDE (Men’s SIZE) GOLD
60428 ANIMALIA AN21A-AC01 CROSS KIHEI Bracelet : WIDE (Men’s SIZE) SILVER
60430 ANIMALIA AN21A-AC03 ZINC CROSS SILVER
60432 ANIMALIA AN21A-AC04 ZINC GOOD LUCK HOOF SILVER
59245 ANIMALIA AN21U-SW01 S/S ZIP-UP HOODIE BLACK
33688 ANIMALIA IPHONE6/6S CASE LIBERTINE BLACK
33689 ANIMALIA IPHONE6/6S CASE LIBERTINE WHITE
43061 ANIMALIA AN18A-AC02 Robber Gloves BLACK
43062 ANIMALIA AN18A-AC02 Robber Gloves OLIVE
63195 ANIMALIA (アニマリア) TANK TOP - logo BLACK
63196 ANIMALIA (アニマリア) TANK TOP - logo WHITE
63197 ANIMALIA (アニマリア) Double Cutaway - logo BLACK
24910 ANIMALIA WOOD SKIN Bag
24077 ANIMALIA ANIMAL-AC11 GOOD LUCK HOOF BRASS
24078 ANIMALIA ANIMAL-AC11 GOOD LUCK HOOF SILVER
24079 ANIMALIA ANIMAL-AC11 GOOD LUCK HOOF BLACK
24080 ANIMALIA ANIMAL-AC12 ZINC CROSS BRASS
24081 ANIMALIA ANIMAL-AC12 ZINC CROSS SILVER
24082 ANIMALIA ANIMAL-AC12 ZINC CROSS BLACK
24902 ANIMALIA GOOD LUCK HOOF BLK
24903 ANIMALIA GOOD LUCK HOOF SILVER
24904 ANIMALIA ZINC CROSS BRASS
24905 ANIMALIA ZINC CROSS SILVER
24906 ANIMALIA ZINC CROSS BLACK
31626 ANIMALIA ANIMAL-AC12 ZINC CROSS BRASS HEADxSILVER CHAIN
65146 ANIMALIA VELCRO WALLET - SKUNK SCOUT
66259 ANIMALIA (アニマリア) ROLL UP BEANIE BLACK
66260 ANIMALIA (アニマリア) ROLL UP BEANIE ORANGE
54223 ANIMALIA S/S SIDE ZIP HOODIE NAVY
63065 ANIMALIA AN22SP-SW07 DOUBLE KNIT HOODIE-Overlap Logo KHAKI
52580 ANIMALIA 49in' BACK PACK
24074 ANIMALIA ANIMAL-AC10 ZINC BANGLE-bull rope BRASS
24075 ANIMALIA ANIMAL-AC10 ZINC BANGLE-bull rope SILVER
24076 ANIMALIA ANIMAL-AC10 ZINC BANGLE-bull rope BLACK
27669 ANIMALIA AN16A-CP07 Low cap #001 WHITExRED
27676 ANIMALIA ANIMAL-AC10 ZINC BANGLE-bull rope SILVER
27677 ANIMALIA ANIMAL-AC10 ZINC BANGLE-bull rope BLACK