sql error!

SELECT gd.id, gd.name, gd.group, gd.brand, gd.content, (SELECT br.name FROM jm_brand as br WHERE br.id = gd.brand) as brand_name, (SELECT br2.rewrite FROM jm_brand as br2 WHERE br2.id = gd.brand) as brand_rewrite, (SELECT br3.country FROM jm_brand as br3 WHERE br3.id = gd.brand) as brand_country, gd.marking, gd.photo_id, gd.describe, gd.price_base, gd.price_sale, gd.curency, gd.schem, gd.extra_photo, gd.cherts, gd.accessorys, gd.direction, gd.articles, gd.video, gd.files, gd.faq, gd.recomend, gd.instructions, gd.rewrite, gd.show_in_sale, gd.sale_reason, gd.price_sale, gd.country FROM jm_catalog as gd WHERE gd.delete = 0 AND gd.id=1738