Россия

Улица Садовническая, 81
115035 Москва, Россия
Мобильный: +79107081162

Италия

Corso Giuseppe Garibaldi, 111
18038 Sanremo (IM)
Mobile: + 393884227146

Класс энергетики:
  • ≤ 50 a
  • 51 - 90 b
  • 91 - 150 c
  • 151 - 230 d
  • 231 - 330 e
  • 331 - 450 f
  • > 450 g
  • Class B


SELECT * FROM (SELECT *, titolo_ru AS titolo, descrizione_ru AS descrizione FROM catalogo WHERE foto=1 AND visualizza_ru=1 AND (cod='dummy' ) AND cod<>211 ORDER BY rand() LIMIT 6) AS immobili LEFT JOIN (SELECT ru as citta, cod AS codcitta FROM citta) AS citta ON (immobili.citta = citta.codcitta) -Got error 28 from storage engine