SELECT
	sucursal.nombre as sucursal,
	cobrador.login as usuario,
	cobrador_partner.name as cobrador,
	(SELECT create_date FROM ir_logging_movil WHERE create_uid = cobrador.id and create_date is not null order by create_date desc limit 1) as ultima_sincronizacion_movil,
	(SELECT app_nombre FROM ir_logging_movil WHERE create_uid = cobrador.id and app_nombre is not null order by create_date desc limit 1) as aplicacion,
	(SELECT app_version FROM ir_logging_movil WHERE create_uid = cobrador.id and app_version is not null order by create_date desc limit 1) as version,
	(SELECT marca FROM ir_logging_movil WHERE create_uid = cobrador.id and marca is not null order by create_date desc limit 1) as marca,
	(SELECT modelo FROM ir_logging_movil WHERE create_uid = cobrador.id and modelo is not null order by create_date desc limit 1) as modelo,
	(SELECT imei FROM ir_logging_movil WHERE create_uid = cobrador.id and imei is not null order by create_date desc limit 1) as imei,
	(SELECT serial FROM ir_logging_movil WHERE create_uid = cobrador.id and serial is not null order by create_date desc limit 1) as numero_serie
FROM
	res_users cobrador
	LEFT JOIN res_partner cobrador_partner ON cobrador.partner_id = cobrador_partner.id
	LEFT JOIN res_sucursal sucursal ON cobrador.sucursal_id = sucursal.id
WHERE
	(select 1 FROM cobranza_recibo WHERE cobrador_id = cobrador.id AND create_date >= NOW() - interval '30 days' limit 1) > 0
ORDER BY sucursal, aplicacion, version, ultima_sincronizacion_movil desc