Query:select * from db_unoxshop.catalogo_cache4 where (online=1 and id_categoria ='4' and ( tipologia ='COOKING ESSENTIALS' )) and ( tipologia not like '%usato%' ) ORDER BY ( SELECT ecommerce_listini_prezzi.prezzo FROM ecommerce_listini_prezzi WHERE ecommerce_listini_prezzi.codice = catalogo_cache4.codice AND ecommerce_listini_prezzi.codice_valuta = 'EUR') DESC limit 0,30

Subquery returns more than 1 row