DELETE FROM commercial_quotes
WHERE (request_type = 'sign' AND request_id IN (
  SELECT id FROM quote_requests WHERE reference LIKE 'TEST-%'
)) OR (request_type = 'textile' AND request_id IN (
  SELECT id FROM textile_quote_requests WHERE reference LIKE 'TEST-%'
));

DELETE FROM quote_requests WHERE reference LIKE 'TEST-%';
DELETE FROM textile_quote_requests WHERE reference LIKE 'TEST-%';
DELETE FROM neon_quote_requests WHERE reference LIKE 'TEST-%';
DELETE FROM professional_applications WHERE email LIKE '%.test@example.com';