SELECT * , get_distance_metres( 46.2087, -1.16597, lat, lon ) AS dist
                FROM `Arfooo_pb_searchville`
                JOIN (

                    SELECT `city` , `zipCode` , `city_search`
                    FROM `Arfooo_Moto_sites`
                    WHERE (`categoryId`=11 or `categoryId`
                    IN (
                    
                    SELECT `categoryId`
                    FROM `Arfooo_Moto_categories`
                    WHERE `parentCategoryId` =11
                    ))
                    GROUP BY `city_search` , `zipCode`
                    ) AS t ON t.`city_search` = `commune_search`
                    AND substring( t.`zipCode` , 1, 2 ) = substring( `code_postal` , 1, 2 )
                WHERE   (lat <>0 AND lon <>0)
                AND id <>6164  
                ORDER BY dist LIMIT 0 , 4<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/purement/annuaire-moto/core/Database.php:233) in <b>/home/purement/annuaire-moto/core/ErrorHandler.php</b> on line <b>154</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/purement/annuaire-moto/core/Database.php:233) in <b>/home/purement/annuaire-moto/core/ErrorHandler.php</b> on line <b>155</b><br />