צימרים בגני תקווה
(1 תוצאות)
Array
(
[0] => Array
(
[0] => 42S22
[SQLSTATE] => 42S22
[1] => 207
[code] => 207
[2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'price_min'.
[message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'price_min'.
)
)
SELECT cabin.name, cabin.id, cabin.phone, cabin.cabinOwner, cabin.cordes_zimmer ,cabin.first_pic_location, cabin.show_pics_nums, Cities.cordes, Cities.url, cabin.settlement, cabin.zones, cabin.address FROM cabin LEFT JOIN Cities ON cabin.zones=Cities.name WHERE cabin.sales<>'*' AND cabin.zones = 'גני תקווה' ORDER BY cabin.price_min - 1 / (1.0 + FLOOR(100 * RAND(CONVERT(VARBINARY, NEWID())))) DESC