allworkers

$sql = "SELECT 
    workers.fname AS fname,
    workers.sname AS sname,
    workers.rep AS rep,
    workers.id AS workerid,
    workers.mobile AS workermobile
FROM workers
GROUP BY workers.id";

$sql = "SELECT     workersassigned.hiredate AS hiredate,
                    jobs.id AS jobid,
                    jobs.jobtitle AS jobtitle
                        
                    FROM workersassigned
                    INNER JOIN workers ON workers.id = workersassigned.workerid
                    INNER JOIN jobs ON jobs.id = workersassigned.jobid
                    WHERE workers.id = $workerid[$key]
                    AND workersassigned.state != 'ended'
                    ";
                    
                
 alljobs
 $sql = "SELECT jobs.*,
            
            jobtype.jobtype AS jobtype,
            jobs.refnumber AS jobref,
            client.clientname AS clientname,
            sites.sitename AS sitename
    FROM jobs
    INNER JOIN jobtype ON jobtype.id = jobs.jobtypeid
    INNER JOIN sites ON sites.id = jobs.siteid
    INNER JOIN client ON client.id = sites.clientid
    WHERE jobs.status = 'open'
    ORDER BY jobs.jobstart";
    
    
     $sql2 = "SELECT 
       jobtype.subjobtype FROM job_subjobtype
       INNER JOIN jobtype ON jobtype.id = job_subjobtype.jobtypeid
       WHERE job_subjobtype.jobid = '".$row['id']."'";
 
    $result2 = "SELECT * FROM workersassigned 
         INNER JOIN jobs 
         ON workersassigned.jobid = jobs.id
         WHERE jobs.refnumber = '".$row['refnumber']."'";         

 
 all messages
 
 $sql = "SELECT * FROM messages
INNER JOIN ( SELECT 
    messages.id AS id, 
    workers.fname AS fname,
    workers.sname AS sname,
    workers.rep AS rep,
    jobs.id AS jobid,
    workers.id AS workerid,
    workers.mobile AS workermobile,
    jobs.jobtitle AS jobtitle,
    jobs.refnumber AS jobref
FROM messages
INNER JOIN workers ON workers.id = messages.workerid
INNER JOIN jobs ON jobs.id = messages.jobrefid)
AS m ON m.id = messages.id
";