SELECT DISTINCT
  sql_no_cache as job.id,
  job.id as job_id,
  job.job_status,
  job.servee_name,
  kase.plaintiff,
  index_number,
  lawfirm_filenumber,
  DATE_FORMAT(job.datetime_received, '%m/%d/%Y') as date_received,
  DATE_FORMAT(job.date_sent_to_court, '%m/%d/%Y') as date_sent_to_court,
  DATE_FORMAT(kase.date_kase_filed, '%m/%d/%Y') as date_kase_filed,
  TO_DAYS(NOW())-TO_DAYS(kase.date_kase_filed) as thedays,
  DATE_FORMAT(kase.court_datetime, '%m/%d/%Y %h:%i %p') as court_date,
  kase.court_room,
  CONCAT( LUcourt.court_county," - ",LUcourt.court_type) as court_name,
  DATE_FORMAT( job.datetime_served, '%m/%d/%Y') as datetime_served,
  CONCAT( server.namefirst,' ', server.namelast) as server_name

FROM      job
LEFT JOIN kase        ON job.kase_id = kase.id
LEFT JOIN kasebilling ON kasebilling.kase_id = kase.id
LEFT JOIN server      ON job.server_id = server.id
LEFT JOIN client      ON client.id     = kase.client_id
LEFT JOIN LUcourt     ON LUcourt.id    = kase.court_id

   WHERE job.subscriber_id = 1
ORDER BY job_id + 0
   LIMIT 0,500;

</pre>
i modified the query but it wont run ...

    SELECT DISTINCT sql_no_cache  job.id, job.id as job_id, job.job_status, job.servee_name, kase.plaintiff, index_number, lawfirm_filenumber, DATE_FORMAT(job.datetime_received, '%m/%d/%Y') as date_received, DATE_FORMAT(job.date_sent_to_court, '%m/%d/%Y') as date_sent_to_court, DATE_FORMAT(kase.date_kase_filed, '%m/%d/%Y') as date_kase_filed, TO_DAYS(NOW())-TO_DAYS(kase.date_kase_filed) as thedays, DATE_FORMAT(kase.court_datetime, '%m/%d/%Y %h:%i %p') as court_date, kase.court_room, CONCAT(LUcourt.court_county," - ",LUcourt.court_type) as court_name, DATE_FORMAT(job.datetime_served, '%m/%d/%Y') as datetime_served, concat(server.namefirst,' ', server.namelast) as server_name FROM job
    LEFT JOIN kase ON job.kase_id = kase.id
    LEFT JOIN kasebilling  ON kasebilling.kase_id = kase.id
    LEFT JOIN server ON job.server_id = server.id
    left join client on client.id=kase.client_id
    left join LUcourt on LUcourt.id=kase.court_id  WHERE job.subscriber_id = 1 and job_id in (select distinct job.id from job where job.subscriber_id = '1' order by id+0) LIMIT 0,500
</pre>

SELECT DISTINCT sql_no_cache  job.id, job.id as job_id, job.job_status, job.servee_name, kase.plaintiff, index_number, lawfirm_filenumber, DATE_FORMAT(job.datetime_received, '%m/%d/%Y') as date_received, DATE_FORMAT(job.date_sent_to_court, '%m/%d/%Y') as date_sent_to_court, DATE_FORMAT(kase.date_kase_filed, '%m/%d/%Y') as date_kase_filed, TO_DAYS(NOW())-TO_DAYS(kase.date_kase_filed) as thedays, DATE_FORMAT(kase.court_datetime, '%m/%d/%Y %h:%i %p') as court_date, kase.court_room, CONCAT(LUcourt.court_county," - ",LUcourt.court_type) as court_name, DATE_FORMAT(job.datetime_served, '%m/%d/%Y') as datetime_served, concat(server.namefirst,' ', server.namelast) as server_name FROM job
LEFT JOIN kase ON job.kase_id = kase.id
LEFT JOIN kasebilling  ON kasebilling.kase_id = kase.id
LEFT JOIN server ON job.server_id = server.id
left join client on client.id=kase.client_id
left join LUcourt on LUcourt.id=kase.court_id  WHERE job.subscriber_id = 1 and job_id in (select distinct job.id from job where job.subscriber_id = '1' order by id+0) LIMIT 0,500

SELECT DISTINCT sql_no_cache  job.id, job.id as job_id, job.job_status, job.servee_name, kase.plaintiff, index_number, lawfirm_filenumber, DATE_FORMAT(job.datetime_received, '%m/%d/%Y') as date_received, DATE_FORMAT(job.date_sent_to_court, '%m/%d/%Y') as date_sent_to_court, DATE_FORMAT(kase.date_kase_filed, '%m/%d/%Y') as date_kase_filed, TO_DAYS(NOW())-TO_DAYS(kase.date_kase_filed) as thedays, DATE_FORMAT(kase.court_datetime, '%m/%d/%Y %h:%i %p') as court_date, kase.court_room, CONCAT(LUcourt.court_county," - ",LUcourt.court_type) as court_name, DATE_FORMAT(job.datetime_served, '%m/%d/%Y') as datetime_served, concat(server.namefirst,' ', server.namelast) as server_name FROM job
LEFT JOIN kase ON job.kase_id = kase.id
LEFT JOIN kasebilling  ON kasebilling.kase_id = kase.id
LEFT JOIN server ON job.server_id = server.id
left join client on client.id=kase.client_id
left join LUcourt on LUcourt.id=kase.court_id  WHERE job.subscriber_id = 1 and job_id in (select distinct job.id from job where job.subscriber_id = '1' order by id+0) LIMIT 0,500

FROM      kase
LEFT JOIN job     ON k.kase_id   = kase.id
                 AND job.subscriber_id = '1' /* condition copied here ... */
LEFT JOIN kb      ON kb.kase_id  = kase.id
LEFT JOIN server  ON job.server_id = server.id
LEFT JOIN client  ON client.id   = kase.client_id
LEFT JOIN LUcourt ON LUcourt.id  = kase.court_id
    WHERE job.subscriber_id = '1'            /* ... but also kept here */
 ORDER BY job.id
    LIMIT 0,500;

FROM
( SELECT * /* you probably have to list & alias column names if necessary */
  FROM      kase
  LEFT JOIN job   ON k.kase_id   = kase.id
      WHERE job.subscriber_id = '1'
   ORDER BY job.id
      LIMIT 0,500
) AS kase_job
/* Now we have 500 rows*/

LEFT JOIN kb      ON kb.kase_id  = kase_job.id
LEFT JOIN server  ON kase_job.server_id = server.id
LEFT JOIN client  ON client.id   = kase_job.client_id
LEFT JOIN LUcourt ON LUcourt.id  = kase_job.court_id

/* If you do `(500 rows) LEFT JOIN whatever` you can be sure you have
   at least 500 rows (never less) here, so you have to ORDER/LIMIT then again
*/

 ORDER BY kase_job.id
    LIMIT 0,500;