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'
) );