CREATE PROCEDURE usp_list_geo_do -- usp_list_geo_do 216
@companyid BIGINT
AS
BEGIN
DECLARE @upline_company_id AS BIGINT=0
DECLARE @upline_master AS BIGINT =0

IF EXISTS(SELECT top 1 ISNULL(c.upline_companyid,0),ISNULL( c.upline_master,0) FROM customer c WITH (NOLOCK) WHERE company_id=@companyid)
    BEGIN
        SELECT
            @upline_company_id = ISNULL(c.upline_companyid,0),
            @upline_master = ISNULL( c.upline_master,0)
            FROM customer c WITH (NOLOCK) WHERE company_id=22535
    END
ELSE
    BEGIN
        SET @upline_company_id=0;
        SET @upline_master = 0
    END

SELECT  a.id AS geo_id,a.[name] AS geo_name FROM tbl_geofence_area a WITH (nolock)
WHERE a.shapeid<=3 AND (a.companyid=@companyid OR a.companyid=@upline_company_id   OR a.companyid =@upline_master) AND a.companyid<>0
END