SELECT `obs_index` FROM ( `dr_spot_observations` , `dr_spot_observations_immatriculations` ) LEFT OUTER JOIN `dr_spot_images` ON `img_index` = `obs_index` WHERE `oim_obs_index` = `obs_index` AND ( `oim_affichage` = '1' OR `obs_mbr_index` = '' ) AND `opr_gen_index` = '3' AND `obs_opr_pay_code` = 'ROU' ;