title: Unknown column '' in 'field list MySQLConnector MySQLException
body: <p>I have a controller class and inside a method of the controller class, I have List Defined as below.</p>
  <pre><code>List&lt;TrackedStoreProductsViewModel&gt; currTrackProds = _context.Tracked_Products.Select(p =&gt; new TrackedStoreProductsViewModel()
          {
              TrackedProducts = p,
              currentPrice = _context.Store_Products.Where(x =&gt; trackedId.Contains(x.product_id)).FirstOrDefault(s =&gt; s.product_id == p.product_id).Product_Price_History.OrderByDescending(pr =&gt; pr.price_timestamp).Select(pr =&gt; pr.price).FirstOrDefault(),
              userEmailId = _context.User_Accounts.FirstOrDefault(u =&gt; u.account_number == p.account_number).email_id,
              userFirstName = _context.User_Info.FirstOrDefault(u =&gt; u.account_number == p.account_number).first_name
          }
           ).ToList();
  </code></pre>
  <p>Here I am getting the following exception error</p>
  <p><a href="https://i.stack.imgur.com/tZH4V.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tZH4V.jpg" alt="enter image description here" /></a></p>
  <p>Here the exception error is 'Unknown column 't.Store_Productsproduct_id' in 'field list'.</p>
  <p>I checked all the models related to this, set up a breakup point stepped in still couldn't find where it is defined that way? Can someone suggest me an approach I can possibly follow to fix this issue?</p>