- $r = dba::p("SELECT `id`, `iaid`, `icid` FROM `item` WHERE `deleted` AND `changed` < UTC_TIMESTAMP() - INTERVAL 60 DAY");
- while ($row = dba::fetch($r)) {
- dba::delete('item', ['id' => $row['id']]);
- if (!empty($row['iaid']) && !dba::exists('item', ['iaid' => $row['iaid']])) {
- dba::delete('item-content', ['id' => $row['icid']]);
- }
- if (!empty($row['icid']) && !dba::exists('item', ['icid' => $row['icid']])) {
- dba::delete('item-content', ['id' => $row['icid']]);
- }
+ $condition = ["`deleted` AND `changed` < UTC_TIMESTAMP() - INTERVAL 60 DAY"];
+ $rows = DBA::select('item', ['id'], $condition);
+ while ($row = DBA::fetch($rows)) {
+ DBA::delete('item', ['id' => $row['id']]);