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 = AND ca.content_asset_type_code IN ("BLOGP") GROUP BY ca.id ORDER BY ca.title ASC
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 'AND ca.content_asset_type_code IN ("BLOGP") GROUP BY ca.id ORDER BY ca.titl' at line 43
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]
×