Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement