
                select
                     count(  * ) AS cnt 
                from
                    -- from
                    PHPLog2 PL
                    left join promed.pmUserCache PUC on PUC.PMUser_id = PL.pmUser_insID
                    left join promed.Controllers CTS on CTS.Controller_Name = PL.Controller
                     left join promed.Methods MTS on MTS.Method_Name = PL.Method 
                    
                    -- end from
                
            where
                -- where
                cast(PL.PHPLog_insDT as date) >= '2022-02-10' and cast(PL.PHPLog_insDT as date) <= '2022-02-10' and PUC.PMUser_Login ilike 'magomedovast' || '%'
                -- end where
            
                
            
