SELECT task_allotments.*,task_allotments.id as id,project_tasks.status as status,project_name,task_name,username,project_tasks.id as pid,project_tasks.rejection_reason FROM task_allotments
left join add_project on task_allotments.project_id=add_project.id
left join project_tasks on task_allotments.task_id=project_tasks.id
left join users on task_allotments.alloted_by=users.id
where alloted_to=0
LIMIT 10 OFFSET 0
