I need some query builder to get result like this :
select
A.`idalbum`, A.`title_en` as `title`,
A.`desc_en` as `description`, A.`cover` as `cover`,
(SELECT COUNT(idgallery) AS gambar FROM gallery WHERE cate='1' AND albumid=A.idalbum) as gambar,
(SELECT COUNT(idgallery) AS videos FROM gallery WHERE cate='2' AND albumid=A.idalbum) as videos,
from `album` as A
what queries i should use? in case, i can't use RAW because i need some paginate on laravel Eloquent
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire