diff options
| author | Bharat Mediratta <bharat@menalto.com> | 2009-05-10 18:44:03 +0000 |
|---|---|---|
| committer | Bharat Mediratta <bharat@menalto.com> | 2009-05-10 18:44:03 +0000 |
| commit | cc0fcc8961b8dd62dfc3ce3c2be9a19e93affdfa (patch) | |
| tree | 204a8ddc469ee4e88fb909510d8bd2bcb73a1ec5 /modules/search/helpers/search_task.php | |
| parent | e6d3d42c225ab37c1d1bae80649b6561be894046 (diff) | |
Use a clearer query syntax for deleting extra search and exif records (thanks Romain LE DISEZ)
Diffstat (limited to 'modules/search/helpers/search_task.php')
| -rw-r--r-- | modules/search/helpers/search_task.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/modules/search/helpers/search_task.php b/modules/search/helpers/search_task.php index 98eba097..d3d4377b 100644 --- a/modules/search/helpers/search_task.php +++ b/modules/search/helpers/search_task.php @@ -21,9 +21,9 @@ class search_task_Core { static function available_tasks() { // Delete extra search_records Database::instance()->query( - "DELETE {search_records}.* FROM {search_records} " . - "LEFT JOIN {items} ON ({search_records}.`item_id` = {items}.`id`) " . - "WHERE {items}.`id` IS NULL"); + "DELETE FROM {search_records} " . + "WHERE {search_records}.`item_id` NOT IN " . + "(SELECT `id` FROM {items})"); // Insert missing search_records Database::instance()->query( |