SELECT q.id AS id FROM `quick_scans` AS q, `product_groups` AS p WHERE q.url = 'improve-resistance' AND q.active = 1 AND q.product_group_id = p.id AND p.active = 1 LIMIT 1