SELECT msg.sid, msg.category_id , msg.for_degree, msg.resource_type, msg.subject, msg.hits, msg.post_date, msg.tags, cat.category, cat.subcategory FROM msgboard msg LEFT JOIN categories cat ON msg.category_id=cat.sid ORDER BY post_date desc,category_id LIMIT :limit OFFSET :offset