SELECT sum(total) AS total FROM ( (SELECT count(*) AS total FROM ( (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='jerry_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='linked.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='condorcity_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='megajobs_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='leforem_be.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='randstad_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='jobsfinancieel_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='vacaturebase_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='megabaan_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='jobstechniek_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='frankwatchin_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='elle_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='ictjobboard_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='red_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='winkelstage_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='zorgspecialisten_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='sante_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='quotenet_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='fiscalert_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='vacaturebase_be.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='jobsfinancieel_be.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='megabaan_be.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='jobstechniek_be.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='ictjobboard_be.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='bouwvacatures_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='jobnews_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='monsterboard.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='monster_be.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='atosorigin.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='brabantvacatures_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='vacant_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='computable_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='inframatch_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='startpeople_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='studentenwerk_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='techniekvacaturebank_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='monsterboard_nl_1.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='monsterboard_nl_2.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='monsterboard_nl_3.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='monsterboard_nl_4.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='monsterboard_nl_5.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='adecco_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='agrojobs_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='12jobs.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='careerbuilder.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='eurojobs_be.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='eurojobs_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='horecajobs.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='ictjobs.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='jobsinfinance.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='monster_be.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='nationalvacaturebank_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='people4you.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='politie.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='stepstone_be.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='stepstone_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='uitzendbureau_nl.php' ORDER BY postdate DESC LIMIT 1000000) UNION (SELECT j1.* ,(6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo))))) AS distance FROM jobs AS j1 LEFT JOIN zipcode AS z1 ON z1.zipcode_id=j1.zipcode_id WHERE 1 AND j1.country_id='NL' AND (6378 * acos(sin(radians(X(z1.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z1.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z1.zipcode_geo)))) < 5) AND source='goudengidsbanen.php' ORDER BY postdate DESC LIMIT 10) ORDER BY search_order DESC, postdate DESC ) s1) UNION ALL (SELECT count(*) AS total FROM ( (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='jerry_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='linked.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='condorcity_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='megajobs_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='leforem_be.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='randstad_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='jobsfinancieel_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='vacaturebase_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='megabaan_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='jobstechniek_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='frankwatchin_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='elle_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='ictjobboard_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='red_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='winkelstage_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='zorgspecialisten_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='sante_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='quotenet_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='fiscalert_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='vacaturebase_be.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='jobsfinancieel_be.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='megabaan_be.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='jobstechniek_be.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='ictjobboard_be.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='bouwvacatures_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='jobnews_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='monsterboard.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='monster_be.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='atosorigin.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='brabantvacatures_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='vacant_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='computable_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='inframatch_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='startpeople_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='studentenwerk_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='techniekvacaturebank_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='monsterboard_nl_1.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='monsterboard_nl_2.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='monsterboard_nl_3.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='monsterboard_nl_4.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='monsterboard_nl_5.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='adecco_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='agrojobs_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='12jobs.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='careerbuilder.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='eurojobs_be.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='eurojobs_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='horecajobs.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='ictjobs.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='jobsinfinance.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='monster_be.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='nationalvacaturebank_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='people4you.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='politie.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='stepstone_be.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='stepstone_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='uitzendbureau_nl.php' ORDER BY postdate DESC LIMIT 1000000, 1000000) UNION (SELECT j2.* ,(6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo))))) AS distance FROM jobs AS j2 LEFT JOIN zipcode AS z2 ON z2.zipcode_id=j2.zipcode_id WHERE 1 AND j2.country_id='NL' AND (6378 * acos(sin(radians(X(z2.zipcode_geo))) * sin(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) + cos(radians(X(z2.zipcode_geo))) * cos(radians(X((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241)))) * cos(radians(Y((SELECT zipcode_geo FROM zipcode WHERE 1 AND zipcode_country='NL' AND zipcode_id=5241))) - radians(Y(z2.zipcode_geo)))) < 5) AND source='goudengidsbanen.php' ORDER BY postdate DESC LIMIT 10, 1000000) ORDER BY postdate DESC ) s2) ) AS total