SELECT c.cid, c.subject, c.nid, c.uid, u.name, c.timestamp, v.fid
FROM bachelor_comments c
LEFT JOIN bachelor_users u ON c.uid = u.uid
LEFT JOIN bachelor_node n ON c.nid = n.nid
LEFT JOIN bachelor_x_vote v ON v.cid=c.cid
WHERE c.status =0
ORDER BY c.timestamp DESC
LIMIT 19 Resource id #120