Thanx for tip here is corrected version for others.
Added pinned_globally=TRUE in where clue
SELECT id, title, user, category_id ,pinned_globally FROM topics WHERE pinned_at IS NOT NULL and pinned_globally=TRUE
{"query":{"id":12,"sql":"SELECT id, title, user, category_id ,pinned_globally FROM topics WHERE pinned_at IS NOT NULL and pinned_globally=TRUE","name":"Pinned Topics","description":"Enter a description here","param_info":[]}}