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 16:35:38')
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 p.update_date
LIMIT 0, 120
22897 ANIMALIA 49ers SOX #002 NAVY
22898 ANIMALIA 49ers SOX #002 WHITE
22900 ANIMALIA BEANIE #005 BLK
22901 ANIMALIA BEANIE #005 RED
22902 ANIMALIA BEANIE #005 GRAY
22903 ANIMALIA SNAPBACK BLACK/BLACK
22904 ANIMALIA SHUNKA MANITO TANKA GRAY
22905 ANIMALIA SHUNKA MANITO TANKA WHT
22906 ANIMALIA HOODIE-Four Coners GRAY
22907 ANIMALIA HOODIE-Four Coners BLACK
22908 ANIMALIA SNAPBACK BLACK/WHTE
23295 ANIMALIA HOODIE-Logo#002 BLACK
23296 ANIMALIA HOODIE-Logo#002 RED
23297 ANIMALIA HOODIE-Logo#002 NAVY
23298 ANIMALIA SW03 Logo#001 BLACK
23299 ANIMALIA SW03 Logo#001 NAVY
23300 ANIMALIA SW03 Logo#001 RED
23730 ANIMALIA AIM WHITE
23731 ANIMALIA AIM KHAKI
23732 ANIMALIA Aged T-shirts LOGO RED
23733 ANIMALIA Aged T-shirts LOGO OLIVE
23734 ANIMALIA Aged T-shirts LOGO BLACK
23735 ANIMALIA Cotton Cardigan NAVY
23736 ANIMALIA Cotton Cardigan GRAY
23966 ANIMALIA AN16U-JK01 Coach Jacket #003 GRAY
23967 ANIMALIA AN16U-JK01 Coach Jacket #003 NAVY
23968 ANIMALIA AN16U-JK02 The Allied Army Nylon Jacket OLIVE
23971 ANIMALIA AN16U-SH01 MOXY #001 BLACK
23973 ANIMALIA AN16U-SH03 BOUND PRISONER #001 GRAY
23975 ANIMALIA AN16U-SH04 SWAGGER #003 RED
23976 ANIMALIA AN16U-SH04 SWAGGER #003 BLACK
23977 ANIMALIA AN16U-SH05 JD No.49 BLACK
23980 ANIMALIA AN16U-SW01 ZIP UP HOODIE-Slashed #001 BLACK
23982 ANIMALIA AN16U-SW02 ZIP UP HOODIE #002 OATMEAL
23990 ANIMALIA AN16U-CS04 BOLD WEST 16su-Logo WHITE
23991 ANIMALIA AN16U-CS04 BOLD WEST 16su-Logo BLACK
23996 ANIMALIA AN16U-CS07 GOLD WEST-Slashed WHITE
23997 ANIMALIA AN16U-CS07 GOLD WEST-Slashed BLACK
24000 ANIMALIA AN16U-CS09 BOUND WEST 16su WHTxNATURAL
24001 ANIMALIA AN16U-CS09 BOUND WEST 16su WHTxNAVY
24002 ANIMALIA AN16U-TE01 ANIMALIA/Disney special item/MICKEY MOUSE Tee WHITE
24003 ANIMALIA AN16U-TE01 ANIMALIA/Disney special item/MICKEY MOUSE Tee INK BLK
24004 ANIMALIA AN16U-TE02 ANIMALIA/Disney special item/GOOFY Tee WHT
24005 ANIMALIA AN16U-TE02 ANIMALIA/Disney special item/GOOFY Tee INK BLK
24006 ANIMALIA AN16U-TE03 LOGO-Leopard WHITE
24007 ANIMALIA AN16U-TE03 LOGO-Leopard BLACK
24008 ANIMALIA AN16U-TE04 GRIZZLY WHITE
24009 ANIMALIA AN16U-TE04 GRIZZLY NAVY
24015 ANIMALIA AN16U-TE07 LOGO-Calligraphy WHITE
24016 ANIMALIA AN16U-TE07 LOGO-Calligraphy BLACK
24018 ANIMALIA AN16U-TE08 LONG HORN BLACK
24019 ANIMALIA AN16U-TE08 LONG HORN OLIVE
24020 ANIMALIA AN16U-TE09 HUPROK WHTxBLACK
24021 ANIMALIA AN16U-TE09 HUPROK WHTxRED
24022 ANIMALIA AN16U-TE09 HUPROK WHTxL.BLUE
24023 ANIMALIA AN16U-TE10 REZ-Tank WHITE
24024 ANIMALIA AN16U-TE10 REZ-Tank BLACK
24025 ANIMALIA AN16U-TE11 Disney special item/MICKEY MOUSE 3/4Sleeve WHTxBLK
24026 ANIMALIA AN16U-TE11 / Disney special item / MICKEY MOUSE 3/4Sleeve WHTxNVY
24027 ANIMALIA AN16U-TE12 Disney special item / GOOFY 3/4Sleeve WHTxBLK
24028 ANIMALIA AN16U-TE12 Disney special item / GOOFY 3/4Sleeve WHTxNVY
24029 ANIMALIA AN16U-TE13 LOGO-Paint TIE DYE NAVY
24030 ANIMALIA AN16U-TE13 LOGO-Paint TIE DYE L.BLUE
24031 ANIMALIA AN16U-TE13 LOGO-Paint TIE DYE RED
24038 ANIMALIA AN16U-PT03 ANGLER #003 BEIGE
24041 ANIMALIA AN16U-PT04 TRACK SHORTS #001 H.BLACK
24042 ANIMALIA AN16U-PT05 REZ-Shorts INDIGO
24043 ANIMALIA AN16U-PT06 JEANS BRONCO #005 WASH INDIGO
24046 ANIMALIA AN16U-CP02 LEOPARD Cap BLACK
24047 ANIMALIA AN16U-CP02 LEOPARD Cap WHITE
24048 ANIMALIA AN16U-CP03 BUCKET HAT-Calligraphy NAVY
24049 ANIMALIA AN16U-CP03 BUCKET HAT-Calligraphy L.BLUE
24050 ANIMALIA AN16U-CP04 GRIZZLY Cap BLACKxRED
24051 ANIMALIA AN16U-CP04 GRIZZLY Cap GRAYxBLACK
24055 ANIMALIA AN16U-CP06 BOONIE Paper Hat #002 BLACK
24056 ANIMALIA AN16U-CP06 BOONIE Paper Hat #002 NATURAL
24060 ANIMALIA AN16S-CP08 BEANIE #006 BLACK
24061 ANIMALIA AN16S-CP08 BEANIE #006 KHAKI
24062 ANIMALIA AN16S-CP08 BEANIE #006 RED
24066 ANIMALIA ANIMAL-AC07 CATTLE DRIVE WALLET BLACK
24067 ANIMALIA ANIMAL-AC07 CATTLE DRIVE WALLET NATURAL
24069 ANIMALIA ANIMAL-AC08 CATTLE DRIVE BUSINESS CARD CASE BLACK
24070 ANIMALIA ANIMAL-AC08 CATTLE DRIVE BUSINESS CARD CASE NATURAL
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
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
24087 ANIMALIA ANIMAL-AC19 CATTLE DRIVE WALLET-bend BLACK
24088 ANIMALIA ANIMAL-AC19 CATTLE DRIVE WALLET-bend NATURAL /BLACKxNATURAL
24094 ANIMALIA ANIMAL-AC26 CONCHO #001 SILVER.BUFFALO
24095 ANIMALIA ANIMAL-AC26 CONCHO #001 SILVER.HATCHET
24098 ANIMALIA ANIMAL-AC28 CA1849 Coin Ring-BRASS BRASS
24100 ANIMALIA ANIMAL-AC30 LIFE TAG-BRASS&SILVER925 BRASSxSILVER925
24102 ANIMALIA ANIMAL-AC32 ZINC RIGGING #002 BRASS
24104 ANIMALIA ANIMAL-AC34 REEF KNOT RING-BRASS BRASS
24109 ANIMALIA AN16S-AC09 WOOD SKIN Pencil Case NATURAL
24111 ANIMALIA AN16U-AC01 DAY PACK #001 BLACK
24115 ANIMALIA AN16U-AC04 TYVEK Tote WHITE
24116 ANIMALIA AN16U-AC05 TYVEK Pouch WHITE
24122 ANIMALIA AN16U-AC13 CONCHO RING #001 BLACK
24123 ANIMALIA AN16U-AC13 CONCHO RING #001 NATURAL
24124 ANIMALIA AN16U-AC14 CONCHO BANGLE #001 BLACK
24125 ANIMALIA AN16U-AC14 CONCHO BANGLE #001 NATURAL
24898 ANIMALIA GOLD WEST BLK
24899 ANIMALIA GOLD WEST WHT
24900 ANIMALIA DOWN TO TEXAS BLUE
24901 ANIMALIA DOWN TO TEXAS NAVY
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
24907 ANIMALIA 49in Back-Pack
24908 ANIMALIA 49in Wallet-bend
24909 ANIMALIA WOOD SKIN Pencil Case