SELECT TOP 500 LINKS.LINK_ID, LINKS.LINK_NAME, LINKS.LINK_DATE, LINKS.LINK_CITY, LINKS.LINK_STATE, LINKS.LINK_ZIP,[cat_ID],[sub_ID] 
 FROM LINKS 
   LEFT OUTER JOIN PRICING ON LINKS.paymentAmount = PRICING.id 
 WHERE (LINKS.Link_Expired >= GETDATE()) AND (LINKS.LINK_APPROVED = 1) AND (PRICING.PID = 2) 
  and LInk_name LIKE  '%%' ORDER BY LINKS.LINK_NAME