Query SELECT SQL_CALC_FOUND_ROWS aggregator_tags.tag, aggregator.*,DATE_FORMAT(aggregator.pubdate,'%b %d, %Y') AS pubdate FROM aggregator, aggregator_tags WHERE (aggregator_tags.item_id=aggregator.id) and  (aggregator.active=1) and (aggregator_tags.tag='ankara') ORDER BY aggregator.id DESC LIMIT 0,20 failed