facebook


 	    

 	 	    
 	        
 	    
 	    
 	    
 	    Query:SELECT * FROM(
        SELECT tb1.id_struttura, tb2.*, tb3.nome
		 FROM catalogo_strutture_prodotti as tb1 
		 inner join catalogo_cache1 as tb2 on tb1.id_prodotto=tb2.id_prodotto
		 INNER JOIN catalogo_strutture AS tb3 ON tb1.id_struttura = tb3.id_struttura
		 WHERE (tb2.online = 1)
		 AND tb3.id_struttura 
		  IN (2, 5, 6, 7, 8, 9, 10, 4, 17, 18, 19, 20, 21, 22, 25, 46, 47, 48, 27, 30, 31, 32, 33, 34, 35, 37, 49, 50, 38, 39, 40, 41, 42, 43, 44, 45, 66, 67, 68, 69, 70, 71 )
AND (
lower(tb2.titolo) like lower('%Anticorpi IA-2A (autoanticorpi-2 associati all'insulinoma%')
OR  lower(tb2.sottotitolo) like lower('%Anticorpi IA-2A (autoanticorpi-2 associati all'insulinoma%')
OR  lower(tb2.descrizione) like lower('%Anticorpi IA-2A (autoanticorpi-2 associati all'insulinoma%')
)
		 GROUP BY tb2.id_prodotto ORDER BY tb2.data DESC 
		) AS tbl
		GROUP BY tbl.id_struttura
	LIMIT 0, 10

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%') OR lower(tb2.sottotitolo) like lower('%Anticorpi IA-2A (autoanticorpi-2 ass' at line 10