Is there a better way to make this mysql query using inner join commands? -

-

in database have several tables "many many" relationships referencing 1 another, , way taught make queries through embedded queries.

i've been reading "many many" relationships, , how query them using "inner join" but, don't seem able find queries fit i'm looking for, , since database work big tables don't want code have performance issues.

select salones.idsalon,         salones.lat,         salones.long,         recursos.idrecurso,         recursos.recurso salones,       recursos,       salones_has_recursos salones_has_recursos.salones_idsalon=salones.idsalon    , salones_has_recursos.recursos_idrecurso=recursos.idrecurso    , recursos.idrecurso in (select idrecurso                              salones_has_recursos                              idrecurso in (select idrecurso                                                  recursos                                                  recurso = 'audiovisual'                                                 )                             )

i know having embedded queries performance killer, way figure how info need table. know how same result using "inner join" commands?

the resulting table should little this

this data content of tables

i'll give starter in hopes can figure out how works:

this:

select idrecurso salones_has_recursos idrecurso in (select idrecurso recursos recursos = 'audiovisual');

becomes:

select    s.idrecurso     salones_has_recursos s   inner join recursos r     on s.idrecurso = r.idrecurso     r.recursos = 'audiovisual';

i can't guarantee work sans means test, think full solution:

select     s.idsalon,     s.lat,     s.long,     r.idrecurso,     r.recurso     salones s    inner join recursos r      on s.idrecurso = r.idrecurso      , r.recursos = 'audiovisual'    inner join salones_has_recursos sr      on sr.salones_idsalon=s.idsalon      , sr.recursos_idrecurso=r.idrecurso;

Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more