$query = sprintf (
               "SELECT `Cats`.`Name`,`Address`.`Address`,`Address`.`City`,`Contact`.`Phone`,`Keys`.`Keywords`
                FROM
                (
                `Cats`
                    LEFT JOIN
                        `Address`
                            USING (`Name`)
                    LEFT JOIN
                         `Contact`      
                            USING (`Name`) 
                    LEFT JOIN
                         `Keys`      
                            USING (`Name`)         
                )
                WHERE
                `Keys`.`Keywords` LIKE '%$search%' 
                ORDER BY name asc LIMIT %d,%d",
                $start - 1,         # number of records to skip
                $per_page + 1);     
}