I am in need of a query to get last photo ID in bx_photos_main to build sys_albums. Instead of eliminating each record besides the last one for each Owner. Trying to build the sys_albums table. I got the query for the sys_albums_objects. but need this one for albums. anybody got a query that will do this.. transfering about 20,000 profiles, with users having 1 to 20 photos each.
Thanks.
Chuck
