select SQL_CALC_FOUND_ROWS listing.*,region.region_name,area.area_name,c.category_name,p.category_parent_name,p.category_parent_id,listing.cost_type, listing.price from listing join region on region.region_id = listing.region_id JOIN area on area.area_id=listing.area_id JOIN category c ON listing.category_id = c.category_id JOIN category_parent p ON c.category_parent_id = p.category_parent_id WHERE listing.active = 'y' and authorised in ('y','p') and expires >= '2010/09/05' AND listing.category_id = 29 AND listing.cust_approved = 'y' order by listing_date desc limit 0,30
