MYSQL ERROR : 1064: 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
`v`.`code` != '0352042'
AND
`a`.`version` = 1' at line 28
SQL : SELECT
`v`.`id`,
`a`.`id` AS `pid`,
`a`.`name`,
`v`.`var_name`,
`v`.`code`,
`v`.`vat`,
0 AS `pricedph`,
`v`.`price` AS `oldprice`,
`v`.`price1` AS `olduprice`,
`v`.`price` - (`v`.`price` / 100 * `v`.`price_discount`) AS `aprice`,
`v`.`price1` - (`v`.`price1` / 100 * `price_discount`) AS `uprice`,
`a`.`definition`,
`a`.`description`,
`a`.`parameters`,
`c`.`name` AS `mark`,
`v`.`price_discount`,
`a`.`visible`,
`a`.`group`,
`g`.`id` AS `g_id`,
`g`.`ext` AS `g_ext`
FROM `shop_product_item_variant` AS `v`
INNER JOIN `shop_product_item` AS `a` ON `v`.`product_id` = `a`.`id`
LEFT JOIN `shop_mark` AS `c` ON `a`.`id_mark` = `c`.`id`
LEFT JOIN `shop_product_gallery` AS `g` ON `g`.`product_id` = `v`.`id` AND `g`.`primary` = '1'
WHERE
`a`.`id` =
AND
`v`.`code` != '0352042'
AND
`a`.`version` = 1
www.angloceska.cz - papírové ubrousky, papírové ručníky, utěrky - {nazev_clanku}