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