From cc0fcc8961b8dd62dfc3ce3c2be9a19e93affdfa Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Sun, 10 May 2009 18:44:03 +0000 Subject: Use a clearer query syntax for deleting extra search and exif records (thanks Romain LE DISEZ) --- modules/exif/helpers/exif_task.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'modules/exif/helpers') diff --git a/modules/exif/helpers/exif_task.php b/modules/exif/helpers/exif_task.php index e6609cec..b6599395 100644 --- a/modules/exif/helpers/exif_task.php +++ b/modules/exif/helpers/exif_task.php @@ -23,9 +23,9 @@ class exif_task_Core { // Delete extra exif_records $db->query( - "DELETE {exif_records}.* FROM {exif_records} " . - "LEFT JOIN {items} ON ({exif_records}.`item_id` = {items}.`id`) " . - "WHERE {items}.`id` IS NULL"); + "DELETE FROM {exif_records} " . + "WHERE {exif_records}.`item_id` NOT IN " . + "(SELECT `id` FROM {items})"); // Insert missing exif_records $db->query( -- cgit v1.2.3