Pogledajte određenu poruku
Staro 28. 05. 2013.   #7
noviKorisnik
Dejan Katašić
Wrote a book
 
Avatar noviKorisnik
 
Datum učlanjenja: 10.06.2005
Lokacija: Novi Sad
Poruke: 1.017
Hvala: 129
86 "Hvala" u 43 poruka
noviKorisnik će postati "faca" uskoro
Default

Kôd:
select * from properties p where 1 = 1
and exists(select * from amenities_properties ap where ap.property_id = p.id and ap.amenity_id = 9)
and exists(select * from amenities_properties ap where ap.property_id = p.id and ap.amenity_id = 15)
and exists(select * from amenities_properties ap where ap.property_id = p.id and ap.amenity_id = 24)
noviKorisnik je offline   Odgovorite uz citat
"Hvala" noviKorisnik za poruku: