Błąd z zapytaniem SQL

[Game94]

Witam posiadam błąd z zapytaniem SQL do zapytania dodaje się: 

SELECT id FROM p_Codes WHERE code=DathSEkv 

Cały log:
 

 mySQL query error: SELECT id FROM p_Codes WHERE code=DathSEkv SELECT c.*,p.Nick admin_name,z.Nick nick_name FROM p_Codes c  LEFT JOIN p_Players p ON ( p.id = c.admin  ) 
 LEFT JOIN p_Players z ON ( z.id = c.used  )   ORDER BY c.data desc

Zapytanie SQL
 

   													
 $this->registry->DB('acc')->allow_sub_select = true;
 $this->registry->DB('acc')->build( array(  'select' => 'c.*',
   'from'  => array('p_Codes' => 'c'),
   'add_join' => array (
    array (
      'select' => 'p.Nick admin_name',
                     'from'   => array( 'p_Players' => 'p' ),
                     'where'  => 'p.id = c.admin ',
                     'type'   => 'left' 
                ),
    array (
      'select' => 'z.Nick nick_name',
                     'from'   => array( 'p_Players' => 'z' ),
                     'where'  => 'z.id = c.used ',
                     'type'   => 'left'
                )
   ),
   'order'=> 'c.data desc'
  ) );

[Macsch15]

Podaj treść błędu.

[Game94]

Błąd naprawiony

Edytowane 23 Listopada 2013 przez Game94

[mrdrifter]

Problem został rozwiązany.