array_get<br>SELECT t1.brand, t2.name, t2.url FROM Product t1 LEFT JOIN brand t2 ON(t1.brand=t2.id) WHERE t1.cat= GROUP BY t1.brandYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY t1.brand' at line 1