SELECT first_paragraph,description,after_description,faq_data FROM course_location_description WHERE course_id = '270' AND spec_id = 47 AND state_id IN( SELECT state_id FROM state_master WHERE state_short_url = 'himachalpradesh' ) AND location_id = ''