View not showing result based on taxonomy term contextual filter

Below is view sql query in Drupal 7

SELECT node.sticky AS node_sticky, node.created AS node_created, node.nid AS nid
FROM 
node
WHERE (( (node.status = 1 OR (node.uid = 96 AND 96 <> 0 AND 1 = 1) OR 1 = 1) AND (node.nid IN  (SELECT tn.nid AS nid
FROM 
taxonomy_index tn
WHERE ( (tn.tid = 'Passed numeric value of taxonomy term') ))) ))
ORDER BY node_sticky DESC, node_created DESC;

Should we go ahead and close this since you asked in a better place for support?

There is an accepted answer to the query on Drupal Answers links in the previous comment.