diff options
| author | plegall <plg@piwigo.org> | 2015-10-09 20:34:35 +0200 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2015-10-09 20:34:35 +0200 |
| commit | 11ccdff58523d10ccc970b879c5de01e7ec40ee2 (patch) | |
| tree | 93bb4b59fd1c70980645422bc24cc2cc1cb46027 /admin/include | |
| parent | 4bf7792c779ee2312de59366afb38f666d49ce46 (diff) | |
| parent | 474942e62d283e392262082a0f544c8b30b17c4c (diff) | |
Merge branch 'feature/357-orphans'
Diffstat (limited to 'admin/include')
| -rw-r--r-- | admin/include/functions.php | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/admin/include/functions.php b/admin/include/functions.php index 7d29f5734..5cd44b31d 100644 --- a/admin/include/functions.php +++ b/admin/include/functions.php @@ -2775,4 +2775,22 @@ SELECT CONCAT( } return $keys; +} + +/** + * Return the list of image ids associated to no album + * + * @return int[] $image_ids + */ +function get_orphans() +{ + $query = ' +SELECT + id + FROM '.IMAGES_TABLE.' + LEFT JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id + WHERE category_id is null +;'; + + return query2array($query, null, 'id'); }
\ No newline at end of file |