pharm tech live; emt and cpt switched to new layout; fixed sql query limits