Database error: Invalid SQL: select distinct a.* , IF (data_fine_lancio > NOW(), 0, IF (a.codice like '%patron%', 1,IF (a.ID_fornitore like '%patron%', 2,IF (a.descrizione_breve like '%patron%', 3,IF (a.descrizione like '%patron%', 4,IF (a.var like '%patron%', 5,6)))))) as rank1, '150.020' as from_categoria from sh_articoli a left join sh_tagkeys t ON t.tipo_tag='CAT' and t.codice_articolo=a.codice and (t.lingua='ALL' OR t.lingua='onnik') and (c.descrizione like '%patron%' ) and tagkey like '150.020%' inner join sh_categorie c ON c.codice=t.tagkey and c.flag_attivo=1 and (c.prefisso='ALL' OR c.prefisso='onnik') and c.codice like '150.020%' inner join sh_tagkeys ti ON ti.tipo_tag='IN_DB' and ti.codice_articolo=a.codice and ti.tagkey='onnik'
where a.flag_validita=1 and ID_fornitore='Novoflex' and (a.codice like '%patron%' OR a.ID_fornitore like '%patron%' OR a.descrizione_breve like '%patron%' OR a.descrizione like '%patron%' OR a.var like '%patron%' ) order by rank1 ASC,a.codice ASC
MySQL Error: 1054 (Unknown column 'c.descrizione' in 'on clause')
Database error: Invalid SQL: select distinct a.* , IF (data_fine_lancio > NOW(), 0, IF (a.codice like '%patron%', 1,IF (a.ID_fornitore like '%patron%', 2,IF (a.descrizione_breve like '%patron%', 3,IF (a.descrizione like '%patron%', 4,IF (a.var like '%patron%', 5,6)))))) as rank1, '150.020' as from_categoria from sh_articoli a left join sh_tagkeys t ON t.tipo_tag='CAT' and t.codice_articolo=a.codice and (t.lingua='ALL' OR t.lingua='onnik') and (c.descrizione like '%patron%' ) and tagkey like '150.020%' inner join sh_categorie c ON c.codice=t.tagkey and c.flag_attivo=1 and (c.prefisso='ALL' OR c.prefisso='onnik') and c.codice like '150.020%' inner join sh_tagkeys ti ON ti.tipo_tag='IN_DB' and ti.codice_articolo=a.codice and ti.tagkey='onnik' where a.flag_validita=1 and ID_fornitore='Novoflex' and (a.codice like '%patron%' OR a.ID_fornitore like '%patron%' OR a.descrizione_breve like '%patron%' OR a.descrizione like '%patron%' OR a.var like '%patron%' ) order by rank1 ASC,a.codice ASC limit 80
MySQL Error: 1054 (Unknown column 'c.descrizione' in 'on clause')
MySQL Error: 1054 (Unknown column 'c.descrizione' in 'on clause')
Database error: Invalid SQL: select distinct a.* , IF (data_fine_lancio > NOW(), 0, IF (a.codice like '%patron%', 1,IF (a.ID_fornitore like '%patron%', 2,IF (a.descrizione_breve like '%patron%', 3,IF (a.descrizione like '%patron%', 4,IF (a.var like '%patron%', 5,6)))))) as rank1, '150.020' as from_categoria from sh_articoli a left join sh_tagkeys t ON t.tipo_tag='CAT' and t.codice_articolo=a.codice and (t.lingua='ALL' OR t.lingua='onnik') and (c.descrizione like '%patron%' ) and tagkey like '150.020%' inner join sh_categorie c ON c.codice=t.tagkey and c.flag_attivo=1 and (c.prefisso='ALL' OR c.prefisso='onnik') and c.codice like '150.020%' inner join sh_tagkeys ti ON ti.tipo_tag='IN_DB' and ti.codice_articolo=a.codice and ti.tagkey='onnik' where a.flag_validita=1 and ID_fornitore='Novoflex' and (a.codice like '%patron%' OR a.ID_fornitore like '%patron%' OR a.descrizione_breve like '%patron%' OR a.descrizione like '%patron%' OR a.var like '%patron%' ) order by rank1 ASC,a.codice ASC limit 80
MySQL Error: 1054 (Unknown column 'c.descrizione' in 'on clause')
|
|
 |