select c.*, h.heading_name,h.web_page_url wpu from plusmart_store_heading h,plusmart_store_category c where c.heading_id=h.heading_id and c.cat_status=1 and c.cust_id='67' and c.store_id='12' and h.store_id='12' and h.prior<100 order by h.prior, h.heading_id