SELECT
'https://' + a.sourceurl + '.11467.com/pifa-' + c.filename + '/' AS url,
a.sourcename,
c.title
FROM
source a
JOIN source b ON b.id = 426
JOIN cat c ON c.id = 233
WHERE
a.ok = 1
AND a.weidu BETWEEN b.weidu - 200 AND b.weidu + 200
AND a.jingdu BETWEEN b.jingdu - 400 AND b.jingdu + 400
AND CONTAINS(a.pcatids, '"|233|"')
ORDER BY
a.data_num DESC