query result error
No: 1064
Msg: 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 'rows FROM products tbl1 WHERE tbl1.productcode IS NOT NULL AND tb...' at line 1
SQL: SELECT COUNT(1) as rows FROM products tbl1 WHERE tbl1.productcode IS NOT NULL AND tbl1.showproduct = 1

Product Listing
Stofpad 4x4
012 654 7723

Product Catalogue

FC001 Hilux Gen 5 bash plate

Toyota Hilux, 1998-2005 Price R3250.00
FC004/01 Hilux Vigo Rear Carrier Bumper

Toyota Hilux Vigo 2005 - 2015 Price R12300.00
FC006 Hilux Standard Bumper

Toyota Hilux Vigo 2005 - 2015 Price R9500.00
FC008 Prado 120 bash plate

Toyota Prado 120 Price R3250.00
FC009 Colt Bashplate (Petrol models)

Mitsubishi Colt Price R3250.00
FC010 Lower Control Arm Skid Plates

Toyota Hilux Vigo 2005 - 2015 Price R2200.00
FC010-02 Front Lower Control Arm Skid Plates

Toyota Fortuner, 2006-Current Price R2200.00
FC0120/01 Isuzu KB6 Rear Carrier Bumper

Isuzu KB6 Price R12300.00
FC014 Defender bash plate

Land Rover Defender Price R3500.00
FC015/01 Isuzu D-max bash plate

Isuzu KB5 Price R3250.00