SELECT ph.photo_id,ph.photo_name,ph.photo_filename,ph.photo_added,ph.photo_premium,ph.photo_adult,ph.photo_free_sample, photo_sets.set_id,photo_sets.set_name,photo_sets.set_added, photo_sets.set_published FROM `photos` as ph STRAIGHT_JOIN photo_sets ON(ph.set_id = photo_sets.set_id) WHERE (SELECT photos_categories.photo_id FROM photos_categories WHERE photos_categories.photo_id = ph.photo_id AND photos_categories.category_id = 259) IS NOT NULL AND photo_sets.approved = 1 ORDER BY photo_sets.set_added DESC, ph.photo_name ASC LIMIT 16,16