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 ') AS is_selected FROM products p LEFT JOIN `brands` b ON p.brands_id' at line 1
Cargos - Big Fish - Large Mens Clothing

Cargos

For a causal look, or for work wear our combats are just right. We stock a wide range of sizes and colours with brands like Lee Cooper and Kam. Durable and Comfortable, what more could you want?! Available in Waist sizes 40", 42", 44", 46", 48", 50", 52", 54", 56", 58" & 60". With leg lengths 29"-34". 

Cargos