Invalid query:
select count(*) as numpromozioni from Aziende where Staticurlen <> '' and Attivo > 0 and convert(substring(Raccomandazioni,3,1),signed) > 0

Unknown column 'Staticurlen' in 'where clause'