title: SQL: Unable to set dynamic variable to OFFSET
body: <p>I'm trying to assign a variable to OFFSET property I tried concat too but I'm not doing it right. First is my original code and the second one is where I've tried to concat the variable to the offset.</p>
  
  <pre><code>SELECT * FROM( SELECT id, title, content, userc_id, created_at, is_deleted FROM stories
  UNION
  SELECT id, heading AS title, description AS content, userc_id, created_at, is_deleted FROM causes
  ) AS a
  JOIN (SELECT clients.* FROM clients) AS b ON a.userc_id = b.id
  LEFT JOIN (SELECT files.* FROM files ) AS c ON c.table_id = a.id AND (c.table = "stories" OR c.table = "causes") 
  WHERE a.is_deleted = 0
  ORDER BY a.created_at
  LIMIT 1
  OFFSET $offset');
  </code></pre>
  
  <p><strong>Please help to me to optimize this code a better way too.
  Here is where I've tried doing concat but I failed miserably.</strong></p>
  
  <pre><code>SELECT * FROM( SELECT id, title, content, userc_id, created_at, is_deleted FROM stories
  UNION
  SELECT id, heading AS title, description AS content, userc_id, created_at, is_deleted FROM causes
  ) AS a
  JOIN (SELECT clients.* FROM clients) AS b ON a.userc_id = b.id
  LEFT JOIN (SELECT files.* FROM files ) AS c ON c.table_id = a.id AND (c.table = "stories" OR c.table = "causes") 
  WHERE a.is_deleted = 0
  ORDER BY a.created_at
  CONCAT(LIMIT 1 OFFSET $offset) ');
  </code></pre>