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 group by products_like.products_id ' at line 12
select sql_calc_found_rows products.*, vat.value vat_value, currencies.symbol currency, designers.name designer, count(products_like.id) num_like from products inner join products_like on products.id = products_like.products_id 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 '2012-05-21' >= date_available and products.virtual_id='0' and products.lang_id='1' and products.category = and products.product_qty > 0 group by products_like.products_id order by num_like desc limit 0, 12