title: Mysql error: violation: 1052 Column 'created_at' in where clause is ambiguous'
body: <p>I am getting the issue:</p>
  <blockquote>
  <p>Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous</p>
  </blockquote>
  <p>but the table <code>sales_flat_order_grid</code> have <code>created_at</code> <strong>Column</strong></p>
  <pre><code>SELECT DISTINCT main_table.*, 
                  blacklist.entity_id AS marked 
  FROM   sales_flat_order_grid AS main_table 
         LEFT JOIN (SELECT main_table.* 
                    FROM   plugincompany_blacklist_item AS main_table 
                    WHERE  ( order_id != '0' ) 
                    GROUP  BY order_id) AS blacklist 
                ON main_table.entity_id = blacklist.order_id 
  WHERE  ( created_at &gt;= '2016-11-03 00:00:00' 
           AND created_at &lt;= '2016-11-26 23:59:59' ) 
  </code></pre>