->select('users.id AS user_id', 'users.name', DB::raw('(CASE WHEN users.status = 0 THEN "active" WHEN users.status = 1 THEN "not active" ELSE "pending" END) AS status_user')) ->orderBy('shares.created_at', 'desc')
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter