I have custom query that works fine. I got pagination show up but the problem is when you click any page number content shows up right but page 1 still remain selected.
I found this that might be the solution: http://codex.wordpress.org/Making_Custom_Queries_using_Offset_and_Pagination
but I was unable to implement it to my code.
Here is my code: http://pastebin.com/EL8iUacP