title: Having a lot of trouble with Yii2 QueryBuilder
body: <pre><code>    public function getOrderItemStatus($magentoorderitemid) {
      $query = (new \yii\db\Query())
          -&gt;select(["COALESCE(ShipTracking.ShipCarrier, '') AS ShipCarrier", "COALESCE(ShipTracking.ShipVendor, '') AS ShipMethod", "COALESCE(ShipTracking.ShipCarrier, '') AS ShipCarrier","COALESCE(ShipTracking.TrackingNumber, '') AS TrackingNumber"])
          -&gt;from('OrderDetails')
          -&gt;leftJoin('PickTicketOrders','PickTicketOrders.OrderId = OrderDetails.OrderId')
          -&gt;leftJoin('ShipTracking', 'ShipTracking.PickTicketId = PickTicketOrders.Id')
          -&gt;leftJoin('Products', 'Products.ISBN = OrderDetails.ISBN')
          -&gt;where('OrderDetails.MagentoOrderItemId=:magentoorderitemid', [':magentoorderitemid' =&gt; $magentoorderitemid]);
      $result = Yii::$app-&gt;db-&gt;createCommand($query)-&gt;execute();
      return $result;
  }
  </code></pre>
  
  <p>Even when I remove the <code>joins</code> and the <code>where</code>, and I change the select to <code>*</code>. It doesn't work</p>