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 ?
Models List
Re: Models List
Don't forget to run script update
Re: Models List
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.
Re: Models List
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)
make a backup ad run this sql query (ask admin to do it for you if you don't know how to do it)
Code: Select all
update rot_gallery_info set gallery_status = 'to_delete' where gallery_id NOT IN (select gallery_id from rot_gal2model)
Don't forget to run script update