SELECT * FROM `service_package_snapshots` as packages, `service_snapshots` as services, `service_packages_links` as links WHERE links.service_package_type='13' AND links.service_package_id=packages.id AND links.service_id=services.id AND packages.owner_type='15' AND packages.owner_id='58' --------------- DELETE FROM `service_package_snapshots` as packages, `service_snapshots` as services, `service_packages_links` as links WHERE links.service_package_type='13' AND links.service_package_id=packages.id AND links.service_id=services.id AND packages.owner_type='15' AND packages.owner_id='58'