SELECT
DISTINCT marca
FROM
Madison_Productos
WHERE
id_cat =
AND
marca != ''
and
marca is not null
and
web=1
AND
Idioma_cook=289
AND
referencia like 'P%'
ORDER BY
marca
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 'AND
marca != ''
and
marca is not null
and
web=1
AND
Idioma_' at line 7
QUERY ERROR:
SELECT DISTINCT estrategia FROM Madison_Productos WHERE id_cat= AND estrategia != '' and estrategia is not null ORDER BY estrategia
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 'AND estrategia != '' and estrategia is not null ORDER BY estrategia' at line 1
QUERY ERROR:
SELECT
Clonica_Port_Productes_Subcat.*
FROM
Clonica_Port_Productes_Subcat,
Madison_Productos
WHERE
Clonica_Port_Productes_Subcat.id_cat =
AND
Madison_Productos.id_subcat= Clonica_Port_Productes_Subcat.id
AND
Clonica_Port_Productes_Subcat.Idioma_cook = '289'
GROUP BY Clonica_Port_Productes_Subcat.id
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 'AND
Madison_Productos.id_subcat= Clonica_Port_Productes_Subcat.id
AND
' at line 8
