title: You have an error in your SQL syntax near ':table_templates_boxes_to_pages
body: <p>Hii i am trying to display data which is present in :table_templates_boxes but not present in :table_templates_boxes_to_pages but i am getting error. Plesrs help me out </p>
  
  <p>Here is my code </p>
  
  <pre><code>SELECT 
    tb.id,
    tb.code 
  FROM
    mxp_templates_boxes tb,
    mxp_templates_boxes_to_pages tbtp 
  WHERE templates_id = 3 
    AND tb.id NOT IN 
    (SELECT 
      templates_boxes_id 
    FROM
      :table_templates_boxes_to_pages) 
  ORDER BY tbtp.sort_order 
  </code></pre>