Saya memiliki kueri yang tidak berfungsi, tampilkan kolom yang tidak diketahui Permintaan saya di zend Framework 2
$select = new Select('dining_table_reservation');
$select->columns(array('range'=>new \Zend\Db\Sql\Expression("CONCAT(5*floor(dining_table.SeatingCapacity/5),'-',5*floor(dining_table.SeatingCapacity/5) + 5)"),'Avgtime'=>new \Zend\Db\Sql\Expression('avg(timestampdiff(SECOND, '.$dtr.'.StartTime, '.$dtr.'.EndTime))')));
$select->join($dt, "$dtr.TableId=$dt.TableId", array('SeatingCapacity'),'INNER');
$select->group(1);
$select->order($dt.'.SeatingCapacity');
tampilan permintaanku
SELECT CONCAT(5*floor(dining_table.SeatingCapacity/5),'-',5*floor(dining_table.SeatingCapacity/5) + 5) AS "range", avg(timestampdiff(SECOND, dining_table_reservation.StartTime, dining_table_reservation.EndTime)) AS "Avgtime", "dining_table"."SeatingCapacity" AS "SeatingCapacity" FROM "dining_table_reservation" INNER JOIN "dining_table" ON "dining_table_reservation"."TableId"="dining_table"."TableId" GROUP BY "1" ORDER BY "dining_table"."SeatingCapacity" ASC
Ini menunjukkan kesalahan:
"Pernyataan tidak dapat dieksekusi (42S22 - 1054 - Kolom tidak diketahui '1' di 'pernyataan grup')"
Apa yang harus saya lakukan ?