Error: Query failed, (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 'GROUP BY ucp.id' at line 1)
Query attempted: SELECT ucp.*, uc.name umbrella_collection, up.name umbrella_product FROM (umbrella_collection_products ucp, umbrella_collections uc, umbrella_products up) WHERE ucp.umbrella_collection_id = uc.id AND ucp.umbrella_product_id = up.id AND ucp.id = GROUP BY ucp.id

Error: Query failed, (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 'GROUP BY up.id' at line 1)
Query attempted: SELECT up.*, COUNT(upi.id) umbrella_product_image_count FROM (umbrella_products up) LEFT JOIN umbrella_product_images upi ON upi.umbrella_product_id = up.id WHERE up.id = GROUP BY up.id

Error: Query failed, (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 'GROUP BY uc.id' at line 1)
Query attempted: SELECT uc.*, COUNT(ucp.id) umbrella_collection_product_count FROM (umbrella_collections uc) LEFT JOIN umbrella_collection_products ucp ON ucp.umbrella_collection_id = uc.id WHERE uc.id = GROUP BY uc.id

::

Click to Enlarge