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-04-24 00:48: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 DESC
LIMIT 480, 120
38571 ANIMALIA AN17A-SW01 RR LOGO BLACK
38572 ANIMALIA AN17A-SW01 RR LOGO NAVY
38573 ANIMALIA AN17A-SW01 RR LOGO GRAY
38574 ANIMALIA AN17A-AC02 SNOOD #003 MIX NAVY
38575 ANIMALIA AN17A-AC02 SNOOD #003 MIX BLACK
38605 ANIMALIA AN17A-JK05 AMA-1 BLACK
38606 ANIMALIA AN17A-JK05 AMA-1 KHAKI
38689 ANIMALIA AN18S-AC08 HORSE BIT Bracelet BRASS
38690 ANIMALIA AN18S-JK04 AUSTERITY JACKET BEIGE
38693 ANIMALIA AN18S-TE06 GOLD BEAR WHITE
38696 ANIMALIA AN18S-KN01 SUM ROBE BLACK
38698 ANIMALIA AN18S-CP03 BOONIE BERET #002 BLACK
38699 ANIMALIA AN18S-CP03 BOONIE BERET #002 NAVY
38701 ANIMALIA AN18S-PT02 TRACK PANTS-REBEL 4 BLACK
38989 ANIMALIA 2018 ANIMALIA LUCKY BAG
39451 ANIMALIA AN18S-TE01 PRISON TATTOO BLACK
39452 ANIMALIA AN18S-TE01 PRISON TATTOO WHITE
39453 ANIMALIA AN18S-AC01 TYVEKC CLUTCH BAG
39454 ANIMALIA AN18S-AC02 PVC POUCH BLACK
39455 ANIMALIA AN18S-AC02 PVC POUCH BEIGE
39839 ANIMALIA FUCKER L/S BLACK
40432 ANIMALIA AN18U-JK02 NRS JACKET BLACK
40434 ANIMALIA AN18U-SH03 BB PLAYER SHIRTS BLACK
40435 ANIMALIA AN18U-SH03 BB PLAYER SHIRTS GRAY
40436 ANIMALIA AN18U-SW02 LOGO SIDE ZIP HOODIE S/S BLACK
40437 ANIMALIA AN18U-SW02 LOGO SIDE ZIP HOODIE S/S GRAY
40440 ANIMALIA AN18U-TE01 USAMA (Champion Body Big silhouette) WHITE
40441 ANIMALIA AN18U-TE08 PATCHES BLACK
40442 ANIMALIA AN18U-TE08 PATCHES WHITE
40443 ANIMALIA AN18U-TE14 EASTERN LOGO-3/4 Sleeve BLACK
40445 ANIMALIA AN18U-TE14 EASTERN LOGO-3/4 Sleeve WHITExDENIM
40446 ANIMALIA AN18U-PT05 TRACK SHORTS-Slashed GRAY
40447 ANIMALIA AN18U-PT05 TRACK SHORTS-Slashed BLACK
40448 ANIMALIA AN18U-CP10 BOONIE BERET #003 BLACK
40450 ANIMALIA AN18U-CP10 BOONIE BERET #003 GRAY
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
40858 ANIMALIA AN18S-AC06 HORSE BIT Necklace
40859 ANIMALIA AN18S-AC09 SIGN PLATE Bracelet
40942 ANIMALIA AC68 LIFE TAG-BLACK titanium
41154 ANIMALIA AN18U-TE04 PARTY HARD (Long Length)
41155 ANIMALIA AN18U-TE04 PARTY HARD (Long Length) WHITE
41156 ANIMALIA ANAN18S-AC13 COTTON BELT #002 BLACK
41157 ANIMALIA ANAN18S-AC13 COTTON BELT #002 WHITE
41330 ANIMALIA AN18U-CP03 KSKUN LOW CAP BLACK
41331 ANIMALIA AN18U-CP03 KSKUN LOW CAP GREEN
41554 ANIMALIA AN18U-CS06 OLD WEST : LOGO (Standard silhouette) BLACK
41555 ANIMALIA AN18U-CS06 OLD WEST : LOGO (Standard silhouette) WHITE
41556 ANIMALIA AN18U-CS06 OLD WEST : LOGO (Standard silhouette) RED
41689 ANIMALIA AN18U-AC07 SASH BELT NAVY
41690 ANIMALIA AN18U-AC07 SASH BELT OLIVE
41691 ANIMALIA ANIMAL-AC82 HORSE BIT Bracelet SILVER
43047 ANIMALIA AN18A-SW06 Grieffiti BLACK
43048 ANIMALIA AN18A-SH04 M40 Snow Parka-Grieffiti BLACK
43049 ANIMALIA AN18A-TE04 PXXCE WHITE
43050 ANIMALIA AN18A-TE04 PXXCE BLACK
43051 ANIMALIA AN18A-AC03 Musette Bag #001 BLACK
43052 ANIMALIA AN18A-AC03 Musette Bag #001 WHITE
43053 ANIMALIA AN18A-SW04 Club Sweat NAVY
43054 ANIMALIA AN18A-SW04 Club Sweat ORANGE
43055 ANIMALIA AN18A-SW05 SIDE ZIP HOODIE L/S BLACK
43056 ANIMALIA AN18A-SW05 SIDE ZIP HOODIE L/S GRAY
43057 ANIMALIA AN18A-TE05 Grieffiti BLACK
43058 ANIMALIA AN18A-TE05 Grieffiti GRAY
43059 ANIMALIA AN18A-CP04 BOONIE Bomber #002 BLACK
43060 ANIMALIA AN18A-CP04 BOONIE Bomber #002 BROWN
43061 ANIMALIA AN18A-AC02 Robber Gloves BLACK
43062 ANIMALIA AN18A-AC02 Robber Gloves OLIVE
43063 ANIMALIA AN18A-AC11 SNOOD #004 BLACK
43064 ANIMALIA AN18A-JK03 AMA Hood Jacket BLACK
43066 ANIMALIA AN18A-JK03 AMA Hood Jacket OLIVE
43067 ANIMALIA AN18A-SW01 Puffy Sweat BLACK
43133 ANIMALIA AN15SP-CP01 SNAPBACK BLACK×RED PAISELY
43134 ANIMALIA AN15SP-CP01 SNAPBACK BLACK×PALM TREE
46161 ANIMALIA(アニマリア) AN19S-PT01 '40s NAVY OVERALLS BLACK
46162 ANIMALIA(アニマリア) AN19S-CP07 ROYAL RUSTIC HAT BLACK
46163 ANIMALIA(アニマリア) AN19S-SW06 MISFIT LOGO SWEAT BLACK
46164 ANIMALIA(アニマリア) AN19S-SW06 MISFIT LOGO SWEAT NAVY
46755 ANIMALIA(アニマリア) AN19S-AC04 KNEE-HIGHS : LOGO BLACK
46756 ANIMALIA(アニマリア) AN19S-AC04 KNEE-HIGHS : LOGO WHITE
46757 ANIMALIA AN19S-AC07 MUSETTE BAG #002 BLACK
46758 ANIMALIA AN19S-AC07 MUSETTE BAG #002 NATURAL
47008 ANIMALIA(アニマリア) AN19S-SH01 WORK SHIRTS AMA MOTORS GRAY
47009 ANIMALIA(アニマリア) AN19S-SH02 WORK SHIRTS SERVO L.BLUE×NAVY
47010 ANIMALIA(アニマリア) AN19S-SH02 WORK SHIRTS SERVO WHITE×GREEN
47011 ANIMALIA(アニマリア) AN19S-CS09 MISFIT - Arm(Loose silhouette) BLACK
47012 ANIMALIA(アニマリア) AN19S-CS09 MISFIT - Arm(Loose silhouette) WHITE
47013 ANIMALIA(アニマリア) AN19S-CS11 MISFIT - Back(Loose silhouette) BLACK
47014 ANIMALIA(アニマリア) AN19S-CS11 MISFIT - Back(Loose silhouette) WHITE
47445 ANIMALIA AN15SP-CP01 BLACK STAR VISORxWHITE刺繍
47448 ANIMALIA AN19A-CP08 '49 Cap : LOGO INDIGOxWHT刺繍
47525 ANIMALIA(アニマリア) AN19S-PT03 JOGGING PANTS MISFIT BLACK×WHT
47526 ANIMALIA(アニマリア) AN19S-PT03 JOGGING PANTS MISFIT NAVY×RED
48255 ANIMALIA AN19U-AC01 METAL PENCIL BOX & 2 BALLPOINT PEN SET BLACK
48256 ANIMALIA AN19U-AC01 METAL PENCIL BOX & 2 BALLPOINT PEN SET RED
48257 ANIMALIA AN19U-CS04 POCKET COVERALL BLACK
48258 ANIMALIA AN19U-CS04 POCKET COVERALL WHITE
48327 ANIMALIA AN19U-TE09 Emperador De America BLACK
48328 ANIMALIA AN19U-TE09 Emperador De America WHITE
48329 ANIMALIA AN19U-TE09 Emperador De America YELLOW
48411 ANIMALIA AN19U-PT03 ARMY Shorts BLACK
48412 ANIMALIA AN19U-PT03 ARMY Shorts OLIVE
48413 ANIMALIA AN19U-PT03 ARMY Shorts TIGER CAMO
49054 ANIMALIA AN19U-SH02 RUGGER SHIRTS BLACK
49229 ANIMALIA AN19U-CS01 SELVAGE-Oil Ticket BLACK
49230 ANIMALIA AN19U-CS01 SELVAGE-Oil Ticket WHITE
49289 ANIMALIA AN19U-AC05 MEXICAN BEADS BRACELET BROWN
49290 ANIMALIA AN19U-AC05 MEXICAN BEADS BRACELET GREEN
49291 ANIMALIA AN19U-AC05 MEXICAN BEADS BRACELET MULTI
49725 ANIMALIA AN19M-TE05 1%er BLACK
49726 ANIMALIA AN19M-TE05 1%er WHITE
49727 ANIMALIA AN19M-TE06 No More Shot BLACK
49728 ANIMALIA AN19M-TE06 No More Shot MINT
49729 ANIMALIA AN19M-TE06 No More Shot WHITE
49730 ANIMALIA AN19M-AC01 WRIST WATCH #001 BLACK
49731 ANIMALIA AN19M-AC01 WRIST WATCH #001 GOLD
49732 ANIMALIA AN19M-AC01 WRIST WATCH #001 SILVER
50360 ANIMALIA AN19M-PT01 JEANS BRONCO No.7 L.BLUE