SELECT * FROM crm_articles INNER JOIN webcrs3_properties ON webcrs3_properties.prop_id=crm_articles.prop_id WHERE crm_articles.id<>'' AND prop_status='active' AND crm_articles.prop_id<>'295' AND crm_articles.lang='fr' AND (crm_articles.prop_code BETWEEN 'ABHB000' AND 'ABHC999' OR crm_articles.prop_code='COMTUR' AND crm_articles.prop_code='FIUME') AND tipologia='' ORDER BY LIMIT 0 , 10 /fr/contenuti/1.html