select slno, category_type, category_name, final_product, as_dynamic_link from bc_product_rei where member_id='1217938' and site_type='rei' and file_name LIKE 'property%'