SELECT alias_entities_publications.*,publications.*, aliastype_entities_publications.type , aliastype_entities_publications.class FROM types AS aliastype_entities_publications,entities AS alias_entities_publications,publications WHERE (type = 'numero' && paraitre != 1 ) AND publications.identity=alias_entities_publications.id AND alias_entities_publications.idtype=aliastype_entities_publications.id AND aliastype_entities_publications.class='publications' AND (alias_entities_publications.status>0) AND (aliastype_entities_publications.status>0) ORDER BY rank DESC LIMIT 0, 10