| Query: | Select site_accommodation_tbl.name as villa_name, site_accommodation_tbl.id as villa_id, def_accommodation_type_tbl.name as accommodation_type_name, guests, bedrooms, bathrooms, area, listing_price, image1 from site_accommodation_tbl inner join def_accommodation_type_tbl on def_accommodation_type_tbl.id = site_accommodation_tbl.accommodation_type where active =1 and destination = and complex = 3 order by -site_accommodation_tbl.position desc, guests asc, site_accommodation_tbl.id |
|---|---|
| Error: | SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and complex = 3 order by -site_accommodation_tbl.position desc, guests asc, s...' at line 13 |