Complex MySQL limit Range

$query = "SELECT c.id as contact_id, c.email, c.name, c.website_name, c.website_url, COUNT(*) as total_emails,
MAX(sent_date) as recent_email, t.clicks, t.views, MAX(t.status) as status, t.post_url, MAX(t.post_date) as post_date
FROM contacts c
 LEFT JOIN emails_sent es ON c.id = es.contact_id 
LEFT JOIN tracking t ON c.id = t.contact_id
GROUP BY c.email
HAVING COUNT(*) = {$_POST['emails_sent']} AND {$condition}
LIMIT 0, {$_POST['contacts']}";

WHERE sent_date < {$edate} AND sent_date > {$sdate}

$query = "
SELECT c.id contact_id
     , c.email
     , c.name
     , c.website_name
     , c.website_url
     , COUNT(*) total_emails
     , MAX(es.sent_date) as recent_email
     , t.clicks
     , t.views
     , MAX(t.status) status
     , t.post_url
     , MAX(t.post_date) post_date
  FROM contacts c 
  LEFT 
  JOIN emails_sent es 
    ON c.id = es.contact_id 
   AND sent_date BETWEEN $sdate AND $edate
  LEFT 
  JOIN tracking t 
    ON t.contact_id = c.id
 GROUP 
    BY c.email
HAVING COUNT(*) = {$_POST['emails_sent']} 
   AND {$condition}
 LIMIT 0, {$_POST['contacts']}";

SELECT DISTINCT contact_id
  FROM emails_sent 
   WHERE sent_date 
     BETWEEN 
     $sdate AND $edate

 LIMIT $con
 LEFT
  JOIN contacts c
    ON c.id = contact_id

WHERE es.sent_date BETWEEN $sdate AND $edate