SELECT p.product_reference_id, '' AS colourlist, (SELECT TOP 1 name FROM main_product_images WHERE product_id = '56723') AS imagepath, (SELECT TOP 1 path FROM main_product_images WHERE product_id = '56723') AS basepath, p.productname, p.product_code AS productcode, md.description, md.print_area, md.is_enhanced_webbuilder, md.product_size, md.lead_time, md.addition_info, p.userid, pr.pricerange, pr.pricerange_eur, pr.pricerange_usd, pr.ordernumber AS 'pricerangeorder', pm.title AS fm_title, pm.meta_title AS fm_meta_title, pm.meta_desc AS fm_meta_desc, pm.meta_keywords AS fm_meta_keywords, pm.imagetag AS imagetag, pdfdata.pdf1, pdfdata.pdf2, pdfdata.low_zip, pdfdata.high_zip, pdfdata.art_pdf FROM main_product AS p LEFT JOIN [user] u ON u.userid = p.userid LEFT JOIN pricerange pr ON p.price_range = pr.pricerangeid LEFT JOIN franchisee_product_meta pm ON ( pm.product_reference_id = p.product_reference_id AND pm.id_franchisee = 9590 ) LEFT JOIN download_product_pdf AS pdfdata ON pdfdata.product_ref_id = p.product_reference_id AND pdfdata.company_id = p.companyid LEFT JOIN main_product_csv pc ON pc.product_id = p.product_reference_id LEFT JOIN main_product_details md ON md.product_id = p.product_reference_id WHERE p.product_reference_id = '56723' AND p.lang_code='en' AND u.isactive = 1