MySQL DELETE with join
Delete a line in a query involving several tables.
Delete a line of the table contract
DELETE c FROM contract c INNER JOIN client cl ON (cl.id = c.client_id) WHERE cl.name = 'tuto4dev' AND c.end_date < NOW()