join - Double results MYSQL query (Drupal database) -

-

i'm trying sql result want join fields users (from drupal database). query looks this:

select * users left outer join field_data_field_wekelijkse_newsletter on users.uid = field_data_field_wekelijkse_newsletter.entity_id                  left outer join field_data_field_woonplaats on users.uid = field_data_field_woonplaats.entity_id                 left outer join field_data_field_naam on users.uid = field_data_field_naam.entity_id

i have 2 problems:

  1. i double results (usernames)
  2. the values "field_data_field_wekelijkse_newsletter" different within double results.

can me write query?

without knowing data model, , going off naming of columns, possible results not duplicates after all. if users can subscribe more 1 newsletter, perhaps happening. returning of fields every table join on. if provide more information such schema definitions, column names, etcetera, can give more precise answer.

in addition, can offer few styling tips in regards writing sql!

  1. use newlines , tabs, write queries developer coming in behind you! readable queriers best (and bug free) queries.

  2. use aliases. typically, treat aliases similar variable names: keep them meaningful , short. if cannot create meaningful, short alias table, use table's initials (for table names such field_data_field_woonplaats, difficult create simple alias! consider renaming)

  3. nomenclature everything! name tables, columns, views, indexes, triggers, keys, everything, (and other developers) can remember them , able grasp , understand kind of object represent (the data hold).

  4. use semicolons terminate statements. 

    select *  users u left outer join field_data_field_wekelijkse_newsletter  fdfwn  on u.uid = fdfwn.entity_id  left outer join field_data_field_woonplaats fdfw   on u.uid = fdfwn.entity_id left outer join field_data_field_naam fdfn  on u.uid = fdfn.entity_id;

Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more