SELECT animals.*, category.name as category, type.name as type, race.name as race, training.name as training FROM animals INNER JOIN category ON animals.id_category = category.id INNER JOIN type ON animals.id_type = type.id INNER JOIN training ON animals.id_training = training.id INNER JOIN race ON animals.id_race = race.id WHERE animals.active = 1 AND animals.id_category =9 LIMIT 0,9