+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Feature Requests (https://forum.codeigniter.com/forumdisplay.php?fid=29)
+--- Thread: Problem with Subqueries (/showthread.php?tid=80189)
Problem with Subqueries - ModeCorot - 09-26-2021
Hello,
I can't transform my sql request into codeigniter,
if someone will help me.
Thank you
SELECT a.id_article, a.title, a.text
FROM articles a
JOIN category c ON a.id_category = c.id_category
WHERE a.id_article = (
SELECT MIN(a2.id_article)
FROM articles a2
WHERE a2.id_category = c.id_category
AND c.id_parent = 4
)
GROUP BY c.id_category
ORDER BY a.id_article ASC
RE: Problem with Subqueries - kenjis - 09-26-2021
You could use $db->query().
See https://codeigniter4.github.io/CodeIgniter4/database/queries.html#regular-queries
RE: Problem with Subqueries - ikesela - 09-27-2021
for subselect
Code:
$builder->where('a.id_article', function(BaseBuilder $builder) {
return $builder->select('MIN(a2.id_article)', false)->from('articles a2')->where('a2.id_category = c.id_category')->where('c.id_parent = 4');
});RE: Problem with Subqueries - ModeCorot - 09-27-2021
(09-27-2021, 03:15 AM)ikesela Wrote: for subselect
Code:$builder->where('a.id_article', function(BaseBuilder $builder) {
return $builder->select('MIN(a2.id_article)', false)->from('articles a2')->where('a2.id_category = c.id_category')->where('c.id_parent = 4');
});
Thank you so much