Table alias in join
Development and Programming
15 years ago
Does anyone know if you can use table aliases in ActiveRecord joins?
Doing the below query just gives me a fatal error saying I’ve run out of memory (with the memory limit set to 250M), but if I remove the table aliases it works.
<?php
$cats = array(1,28);
$this->EE->db->select('*');
$this->EE->db->join('exp_category_posts as cp', 'cp.entry_id = t.entry_id');
$this->EE->db->join('exp_channel_data as d', 'd.entry_id = t.entry_id');
$this->EE->db->join('exp_categories as c', 'c.cat_id = cp.cat_id');
$this->EE->db->where('t.channel_id', 3);
$this->EE->db->where_in('cp.cat_id', $cats);
$query = $this->EE->db->get('exp_channel_titles as t');
var_dump($query);
?>Is there something special I have to do to get an alias to work or will they just not work in this situation?
15 years ago
Odd, we use them all over the place in the EE Core code. If you EXPLAIN the raw query, what do you get?
-greg
15 years ago
You mean like?
EXPLAIN SELECT * FROM exp_channel_titles as t
JOIN exp_category_posts as cp ON cp.entry_id = t.entry_id
JOIN exp_channel_data as d ON d.entry_id = t.entry_id
JOIN exp_categories as c ON c.cat_id = cp.cat_id
WHERE t.channel_id = 3 AND cp.cat_id IN (1,28)I get this
15 years ago
double odd.
What’s the exact error? How many queries are on the pages? Front end or back end?
15 years ago
The error is
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in web/content/system/codeigniter/system/database/DB_driver.php on line 1176
It’s running in a template and the only code in it is what I posted above.