Need MySQL Query to get last photo ID of user for

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.



Quote · 26 Apr 2017
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.