SQL Hiba: 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 products.product_qty > 0 and products.public='1' ' at line 10
select sql_calc_found_rows products.*, vat.value vat_value, currencies.symbol currency, designers.name designer from products inner join vat on vat.id=products.vat_id inner join currencies on currencies.id = products.currency_id left outer join designers on designers.id = products.designer where '2014-09-01' >= date_available and products.virtual_id='0' and products.deleted = '0' and products.lang_id='1' and products.category = and products.product_qty > 0 and products.public='1' order by new_product desc, products.date_added desc limit 0, 15