Models List

Post by **admin** » Mon Dec 05, 2016 5:31 pm

Well, I checked the Db and you have ~45k galleries and only ~2k "model to gallery" records

That you delete most of your DB

are you sure ?

happydg · Post by **happydg** » Tue Dec 06, 2016 1:01 am

I have many import sets running so new galleries are added everyday. But i would need an option to delete galleries without models from time to time.

Post by **admin** » Tue Dec 06, 2016 4:41 am

ok
make a backup ad run this sql query (ask admin to do it for you if you don't know how to do it)

update rot_gallery_info set gallery_status = 'to_delete' where gallery_id NOT IN (select gallery_id from rot_gal2model)