Error Message:

Query:

SELECT ca.id, ca.title, ca.summary_description, ca.author, ca.content_asset_type_code, bp.page_canonical_url AS blog_post_canonical_url, imbp.host_url AS addendum_blog_post_image_url, imbp.alt_text AS addendum_blog_post_image_alt_text, rec.page_canonical_url AS addendum_recipe_canonical_url, imrec.host_url AS addendum_recipe_image_url, imrec.alt_text AS addendum_recipe_image_alt_text, rk.page_canonical_url AS resource_canonical_url, imrk.host_url AS addendum_resource_image_url, imrk.alt_text AS addendum_resource_image_alt_text FROM content_asset_project_brand_products capbp LEFT JOIN content_assets ca ON capbp.content_asset_id = ca.id LEFT JOIN audios au ON ca.id = au.content_asset_id LEFT JOIN documents do ON ca.id = do.content_asset_id LEFT JOIN videos vi ON ca.id = vi.content_asset_id LEFT JOIN blog_posts bp ON ca.id = bp.content_asset_id LEFT JOIN images imbp ON (bp.image_id = imbp.content_asset_id AND imbp.size = "Blog Post" AND imbp.usage_size = "Small" AND /* imbp.usage_shape = "Block" AND */ imbp.format = "JPG") LEFT JOIN recipes rec ON ca.id = rec.content_asset_id LEFT JOIN images imrec ON (rec.image_id = imrec.content_asset_id AND imrec.size = "Recipe" AND imrec.usage_size = "Small" AND imrec.usage_shape = "Block" AND imrec.format = "JPG") LEFT JOIN resource_kits rk ON ca.id = rk.content_asset_id LEFT JOIN images imrk ON (rk.image_id = imrk.content_asset_id AND imrk.size = "Resource" AND imrk.usage_size = "Small" AND imrk.usage_shape = "Block" AND imrk.format = "JPG") WHERE capbp.project_brand_product_usage_id = GROUP BY ca.id ORDER BY ca.title ASC

System Response:

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 'GROUP BY ca.id ORDER BY ca.title ASC' at line 43

Next Step:

Please contact the System Administrator if you need help with this error message. Copy and paste the entire text on this page and email it to [email protected]