A PHP Error was encountered

Severity: Warning

Message: A non-numeric value encountered

Filename: controllers/products.php

Line Number: 340

Database Error

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-12,12' at line 1

SELECT t.prod_id as id, t.prod_id, t.`table`, t.cervitid, t.vis, t.is_package, t.`code`, t.ean_code, t.title, t.manuf, t.cat, t.subcat, t.model, t.moneda, t.price, t.cota_tva, t.priceincltva, t.priceincltvalei, t.specialprice, t.specialpriceown, t.specialpricedatestart, t.specialpricedateend, t.pricelei, t.priceleiown, t.specialpricedatestartown, t.specialpricedateendown, t.pretimport, t.monedaimport, t.cursimport, t.transportimport, t.cotaadaos, t.marjadistribuitor, t.pretdistribuitor, t.offer, t.txt_offer, t.offpage, t.garant, t.`desc`, t.misc, t.misctext, t.uniquedesc, t.updated, t.prod_dim, t.prod_dim_height, t.prod_dim_length, t.prod_dim_width, t.prod_weight, t.prod_weightfiz, t.supplier, t.presvideo, t.accessories_assoc, t.package_content, t.resigilat_assoc, t.filter_price, t.filter_stock, t.filter_age, t.filter_gender, t.filter_producttype, t.filter_productsubtype, t.filter_weight, t.filter_appliance, t.filter_reza, t.filter_character, t.filter_rezc, t.filter_material, t.filter_marime, t.filter_age_start, t.filter_age_end, t.date_logistice_completate, IFNULL(v.cantitate,0) as newcant, IF((SELECT IFNULL(COUNT(id),0) as cu_marimi FROM size_productsbebe WHERE prod_id = t.prod_id AND `table` = t.`table` LIMIT 1) > 0, (SELECT SUM(marime_stock+marime_stock_rezervat_site) as row_stock FROM size_productsbebe WHERE prod_id = t.prod_id AND `table` = t.`table` AND age_size <> 2 AND age_size <> 0 AND active = 'yes' ORDER BY row_stock DESC), (SELECT SUM(stock+stock_rezervat_site) as row_stock FROM img_productsbebeextrainfo WHERE prod_id = t.prod_id AND `table` = t.`table` AND img_color <> 2 AND img_color <> 18 AND img_color <> 27 AND active = 'yes' ORDER BY row_stock DESC)) as stock from list_allproducts as t left join most_buyed_products as v ON (t.`cervitid`=v.cod) WHERE t.vis = 1 AND t.`table` = 'prod_jucarii' AND t.cat = 'Stickere%20decorative' AND (t.supplier = 'F100' OR t.supplier = 'F101' OR t.supplier = 'F190' OR t.supplier = 'F200' OR t.supplier = 'F201' OR t.supplier = 'F202' OR t.supplier = 'F400' OR t.supplier = 'F700' OR t.supplier = 'F600') GROUP BY t.cervitid order by IF(stock>0,'in stoc','stoc epuizat') ASC,newcant desc LIMIT -12,12

Filename: /home/perea/public_html/cervitonline.ro/libraries/generallib.php

Line Number: 840