SELECT emp_asofam.*, familias.foto, familias.* FROM emp_asofam LEFT JOIN familias ON emp_asofam.cod_fammar=familias.cod WHERE cod_famdis=84433 AND cod_distrib='2252' AND en_tienda AND privada=0 AND cod_marca IN (SELECT cod_emp FROM emp_asociadas WHERE cod_sub='2252' AND ok_emp)GROUP BY cod_fammar