# check for missing rels SELECT p.id, p.name, rsp.source_id, p.url FROM aps_products p left join aps_rel_source_product rsp ON p.id = rsp.product_id WHERE rsp.source_id IS NULL LIMIT 50 # insert rels # CHANGE: source_id and url like INSERT INTO aps_rel_source_product ( source_id, product_id ) SELECT '1', p.id FROM aps_products p left join aps_rel_source_product rsp ON p.id = rsp.product_id WHERE rsp.source_id IS NULL and p.url like '%www.pacopetshop.it%'