$q="SELECT cp.id as cp_id,
                                               cp.image as cp_image,
                                               cp.thumbnail as cp_thumbnail,
                                               cp.creator as cp_creator,
                                               cp.albumid as cp_albumid,
                                               cfv_name.value as cfv_name_value,
                                               cfv_surname.value as cfv_surname_value,
                                               cfv_country.value as cfv_country_value,
                                               cfv_city.value as cfv_city_value 
                                        
                                        FROM #__community_photos AS cp
                                        
                                        LEFT JOIN #__community_fields_values AS cfv_name
                                        ON cfv_name.user_id = cp.creator AND cfv_name.field_id = 17

                                        LEFT JOIN #__community_fields_values AS cfv_surname
                                        ON cfv_surname.user_id = cp.creator AND cfv_surname.field_id = 18
                                        
                                        LEFT JOIN #__community_fields_values AS cfv_country
                                        ON cfv_country.user_id = cp.creator AND cfv_country.field_id = 11
                                        
                                        LEFT JOIN #__community_fields_values AS cfv_city
                                        ON cfv_city.user_id = cp.creator AND cfv_city.field_id = 10                                        
                                
                                
                                        WHERE cp.published='1' 
                                        
                                        
                                        ORDER BY cp.to_day DESC, cp.to_day_hits DESC LIMIT 10 
                                        
                                        ";