sql query not working with DB::select

First of all can you put your code in the ``` so everyone can actually read this: https://help.github.com/articles/basic-writing-and-formatting-syntax/#quoting-code

So I can't really debug this for you because it's a huge query and I have no idea how your database looks like...

My advice would be to partially build up the query and start from there. So first the normal select and then add one union select and so on!

i rewrite the code for you :

$first = DB::table('dealers')
            ->select('id' ,'fname', 'last_order_date' , 'created_at', 'masterdealers as Source', 'null as type') 
                         ->select(DB::raw('(select id as uuid from uuids WHERE userable_type LIKE "____m%" AND userable_id = masterdealers.id) as uuid'))

$second = DB::table('customers')
            ->select('id' ,'fname','last_order_date' , 'created_at', 'dealers as Source' , 'null as type')
            ->select(DB::raw('(select id as uuid from uuids WHERE userable_type LIKE "____m%" AND userable_id = masterdealers.id) as uuid'))


$results = DB::table('masterdealers')
            ->select('id' ,'fname' , 'last_order_date' , 'created_at', 'masterdealers as Source', 'null as type')
            ->select(DB::raw('(select id as uuid from uuids WHERE userable_type LIKE "____m%" AND userable_id = masterdealers.id) as uuid'))
            ->where('created_at','>=',$startDate)
            ->where('created_at','<=', $endDate)
            ->unionAll($first)
                        ->unionAll($second)
            ->get();

Do you still have a question?

@mballaag i got following error

Parse error: syntax error, unexpected '____m' (T_STRING), expecting ',' or ')'

@hassanraza504 i update the code above. please retry.

What is the error right now?