1. Get all IDs of active products
SELECT id FROM tbldesign WHERE statusID = 'Active';
2. Turn off all products
UPDATE tbldesign SET statusID = 'On Hold' WHERE statusID = 'Active';
3. Convert to CSV format
4. Enter all IDs to set back live
UPDATE tbldesign SET statusID = 'Active' WHERE id IN (*IDs*);
UPDATE tbloccassion SET STATUS = 'Active' WHERE id IN (*IDs*);
UPDATE tbldesigntype SET STATUS = 'Active' WHERE id IN (*IDs*);