Query returned 0 rows for ad_id 3079823

select
a.ad_id as ad_id,
ent.reg_number,
ent.make_model_mismatch_p
from car_ads a
inner join car_makes mk on a.make_id = mk.make_id
inner join car_models md on a.model_id = md.model_id
left join car_ad_reg_entry ent on a.ad_id = ent.ad_id
where (ent.ad_id is null or ent.photos_changed_p = 1 or make_model_mismatch_p = 1)
and (a.reg_number is null or a.reg_number = '' or a.reg_number regexp "^[0-9]+$" or a.reg_number regexp "^[A-Z]+$")
and a.main_image_id is not null
and (a.creation_user is null or a.creation_user not in (71766, 72111, 72113, 72112, 394))
and a.status = 'approved'
and a.expiry_date > sysdate()

  limit 27, 1