SELECT DISTINCT e.jobId, e.act_date, e.activity, j.pricequote, j.sampleStatus
FROM tblEditorActivities AS e, jobs AS j
WHERE (
e.IS_PROCESSED = 'NO' || ( j.sampleStatus = 'PQ' && j.pricequote >500 )
)
AND (
j.jobID = e.jobId
)
LIMIT 0 , 30

--------------------------------------------------------------------------

SELECT hs.TEMPLATE_ID, hs.EMAIL_SUBJECT, hs.EDITOR_COMMENTS, hs.EMAIL_DATE, hs.DELIVERY_FILEID, ET.EMAIL_TITLE, ET.EMAIL_TYPE_ID, EE.EMAIL_TYPE_ID, EE.TEMPLATE_NAME, jd.DELIVERY_FILENAME
FROM `tblEmailHistory` AS hs, tblEmailTypes AS ET, tblEmailTemplates AS EE, tblJobsDelivered AS jd
WHERE hs.TEMPLATE_ID = EE.TEMPLATE_ID
AND EE.EMAIL_TYPE_ID = ET.EMAIL_TYPE_ID
AND hs.jobId =6782
AND jd.DELIVERY_FILEID = hs.DELIVERY_FILEID
LIMIT 0 , 30