function getTariByTheme($ThemeID = false) { $oraseByTheme = Tari::join('hoteluri', 'geo_tari.AidaID', '=', 'hoteluri.Country')->select('geo_tari.id', 'geo_tari.Name')->distinct('geo_tari.id')->where('hoteluri.Themes', 'LIKE', '%|' . $ThemeID . '|%')->where('geo_tari.Activ', 1)->orderBy('geo_tari.id', 'asc')->get(); return $oraseByTheme; }