Select a.* from #__osrs_expired as a inner join #__osrs_properties as b on b.id = a.pid where DATE(DATE_ADD(a.expired_vetrina, INTERVAL 4 DAY)) > '2024-04-28 21:47:09' and a.expired_vetrina != '0000-00-00 00:00:00' and a.send_inform_vetrina = '0' and b.approved = '1' and a.pid not in (Select pid from #__osrs_queue where `emailtype` = 1 and `tipo` = 'vetrina')