Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='949' AND additional=1) OR DoctorInfo.PAreaCode='949') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='949' AND additional=1) OR DoctorInfo.PAreaCode='949') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='949' AND additional=1) OR DoctorInfo.PAreaCode='949') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='949' AND additional=1) OR DoctorInfo.PAreaCode='949') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='949' AND additional=1) OR DoctorInfo.PAreaCode='949') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='949' AND additional=1) OR DoctorInfo.PAreaCode='949') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='949' AND additional=1) OR DoctorInfo.PAreaCode='949') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='949' AND additional=1) OR DoctorInfo.PAreaCode='949') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='309' AND additional=1) OR DoctorInfo.PAreaCode='309') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE DoctorInfo.Defaultdoc='Yes' AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='0' AND additional=1) OR DoctorInfo.PAreaCode='0') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='209' AND additional=1) OR DoctorInfo.PAreaCode='209') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='209' AND additional=1) OR DoctorInfo.PAreaCode='209') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='209' AND additional=1) OR DoctorInfo.PAreaCode='209') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='209' AND additional=1) OR DoctorInfo.PAreaCode='209') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='209' AND additional=1) OR DoctorInfo.PAreaCode='209') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='209' AND additional=1) OR DoctorInfo.PAreaCode='209') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='209' AND additional=1) OR DoctorInfo.PAreaCode='209') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='209' AND additional=1) OR DoctorInfo.PAreaCode='209') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='740' AND additional=1) OR DoctorInfo.PAreaCode='740') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='740' AND additional=1) OR DoctorInfo.PAreaCode='740') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='740' AND additional=1) OR DoctorInfo.PAreaCode='740') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='740' AND additional=1) OR DoctorInfo.PAreaCode='740') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='740' AND additional=1) OR DoctorInfo.PAreaCode='740') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='740' AND additional=1) OR DoctorInfo.PAreaCode='740') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='740' AND additional=1) OR DoctorInfo.PAreaCode='740') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='740' AND additional=1) OR DoctorInfo.PAreaCode='740') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='734' AND additional=1) OR DoctorInfo.PAreaCode='734') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='702' AND additional=1) OR DoctorInfo.PAreaCode='702') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='702' AND additional=1) OR DoctorInfo.PAreaCode='702') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='702' AND additional=1) OR DoctorInfo.PAreaCode='702') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='702' AND additional=1) OR DoctorInfo.PAreaCode='702') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='702' AND additional=1) OR DoctorInfo.PAreaCode='702') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='702' AND additional=1) OR DoctorInfo.PAreaCode='702') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='702' AND additional=1) OR DoctorInfo.PAreaCode='702') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='702' AND additional=1) OR DoctorInfo.PAreaCode='702') AND DoctorInfo.VasectomyPos=8
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=1
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=2
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=3
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=4
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=5
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=6
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=7
Doctor List Left - SELECT DoctorInfo.Defaultdoc, DoctorInfo.DoctorID, DoctorInfo.LastName, DoctorInfo.FirstName, DoctorInfo.Title, DoctorInfo.Image, DoctorInfo.email, DoctorInfo.City, DoctorInfo.StateID, DoctorInfo.ZipCode, DoctorInfo.PAreaCode, DoctorInfo.DefaultDoc, DoctorInfo.VasectomyPos, DoctorInfo.ReversalPos, DoctorInfo.Shortdesc,DoctorInfo.VasectomyPos, State.State, State.StateLC FROM DoctorInfo INNER JOIN State ON DoctorInfo.StateID=State.StateID LEFT OUTER JOIN relAdditionalAreaCodes ON relAdditionalAreaCodes.pAreaCode =DoctorInfo.PAreaCode WHERE  (doctorinfo.doctorId in (SELECT docId from relAdditionalAreaCodes a where a.pAreaCode ='281' AND additional=1) OR DoctorInfo.PAreaCode='281') AND DoctorInfo.VasectomyPos=8