Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

gmartha07's avatar

Query SQL

Hello. Can anyone help me to build this query in Laravel 5?

(SELECT , (SELECT COUNT() FROM posts_likes AS tbl_likes WHERE tbl_likes.id_post = tbl_posts.id) AS likes, (SELECT COUNT(*) FROM posts_likes AS tbl_likes WHERE tbl_likes.id_post = tbl_posts.id AND tbl_likes.usuario='$userid') AS liked FROM posts_blog AS tbl_posts")

I don't know how to do this in laravel.

Thanks

0 likes
1 reply
shakti's avatar

you can used nested query in laravel with the help of selectraw

something like

$categories = \DB::table('posts_blog AS tbl_posts')
    ->select(\DB::raw('tbl_posts.*,(SELECT COUNT() FROM posts_likes AS tbl_likes WHERE tbl_likes.id_post = tbl_posts.id) AS likes, (SELECT COUNT(*) FROM posts_likes AS tbl_likes WHERE tbl_likes.id_post = tbl_posts.id AND tbl_likes.usuario='$userid') AS liked )
    
    ->get();

Please or to participate in this conversation.