API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 6th, 2020
312
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 32.44 KB | None | 0 0
raw download clone embed print report
  1. -- [2020-04-06 09:06:53 GMT] [13908] LOG:  duration: 2296.807 ms  execute <unnamed>:
  2.  
  3. SELECT DISTINCT r0_.id AS id_0, (SELECT true AS sclr_2 FROM Restaurants r1_ LEFT JOIN restaurant_open_period r3_ ON r1_.id = r3_.restaurant_id LEFT JOIN open_period o2_ ON o2_.id = r3_.open_period_id WHERE ((((o2_.week_day = EXTRACT(ISODOW FROM '2020-04-06 12:06:51'::timestamp) OR
  4. o2_.week_day IS NULL) AND ('12:06:51' BETWEEN o2_.open_time AND o2_.close_time)) OR
  5. o2_.id IS NULL) AND r1_.id = r0_.id) AND (r1_.enabled = '1') AND (r1_.in_sync is not false)) AS sclr_1, ST_Distance(r4_.geolocation, ST_Point(27.592419, 53.936439), true) AS sclr_3, r0_.id AS id_4 FROM Restaurants r0_ LEFT JOIN restaurant_info r5_ ON r0_.id = r5_.restaurant_id LEFT JOIN restaurant_info_kitchen r7_ ON r5_.id = r7_.restaurant_info_id LEFT JOIN kitchen k6_ ON k6_.id = r7_.kitchen_id LEFT JOIN restaurant_address r8_ ON r5_.id = r8_.restaurant_info_id LEFT JOIN config c9_ ON r0_.config_id = c9_.id LEFT JOIN restaurant_open_period r11_ ON r0_.id = r11_.restaurant_id LEFT JOIN open_period o10_ ON o10_.id = r11_.open_period_id LEFT JOIN restaurant_info r12_ ON r0_.id = r12_.restaurant_id LEFT JOIN restaurant_address r4_ ON r12_.id = r4_.restaurant_info_id WHERE (r0_.id IN (SELECT r13_.id FROM Restaurants r13_ LEFT JOIN restaurant_info r14_ ON r13_.id = r14_.restaurant_id LEFT JOIN restaurant_info_kitchen r16_ ON r14_.id = r16_.restaurant_info_id LEFT JOIN kitchen k15_ ON k15_.id = r16_.kitchen_id LEFT JOIN restaurant_address r17_ ON r14_.id = r17_.restaurant_info_id LEFT JOIN config c18_ ON r13_.config_id = c18_.id LEFT JOIN restaurant_open_period r20_ ON r13_.id = r20_.restaurant_id LEFT JOIN open_period o19_ ON o19_.id = r20_.open_period_id LEFT JOIN restaurant_info r21_ ON r13_.id = r21_.restaurant_id LEFT JOIN restaurant_address r22_ ON r21_.id = r22_.restaurant_info_id
  6. WHERE (
  7.     ST_Within(ST_Point(27.592419, 53.936439), r21_.delivery_zone) = true AND (
  8.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '0060944df335d16c5b4d99c010309edf' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 6715.00356432) OR
  9.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '0065d31830b0695af58f92b47d1eb1d2' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4207.79116578) OR
  10.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '0074350129f3b7f6d5ff52016ab1bcff' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2137.8653694) OR
  11.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '017ea6a5eb4f7609b635cc3a7d8f3b41' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5343.84644515) OR
  12.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '07b8554acdbce75ba4b02660942ec786' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 6462.30757289) OR
  13.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '08aa0ae6a4a9d04391c99db763d96bee' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3029.99390895) OR
  14.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '09b399d0df0c0f235c8760aa462a62de' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5348.07602327) OR
  15.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '0bfaf50193ccb932206ff948add10497' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3246.76161016) OR
  16.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '0f36dc356670c736e5ee96e4b9028bd3' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2378.40813159) OR
  17.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '0f6b8935d4dba2b34e430e7d5f9a9ded' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5949.18721307) OR
  18.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '0f7110ed97d14b3c42fa29627e799a50' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5207.58255817) OR
  19.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '109302944bee8acce01631630b18a35f' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 6458.12984291) OR
  20.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '114b2e6ea65f1f5f905363fc824893ce' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3064.01917406) OR
  21.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '13302379524e96a376625a54ddc95291' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4680.7256507) OR
  22.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '145ce5c32a9f4b14aebbbd79477bf4b8' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4320.07612147) OR
  23.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '15fc6a8d2998e835b48b7a18f3adf4ed' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4619.30187424) OR
  24.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '16523c606032eff699a92fb23deaf521' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4942.47057129) OR
  25.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '1679091c5a880faf6fb5e6087eb1b2dc' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3935.95322363) OR
  26.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '16933c69bf5ed5d193e09e3d2a6fb42d' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2335.88317891) OR
  27.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '17997e9186dea77d735f962d56e9e38f' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5237.68598262) OR
  28.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '1b3c1b6d07b2bb91f4480c4e9c5c4d41' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3430.23445011) OR
  29.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '1c58d8ebe9bef88c5fb6e5a538f1dd9f' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 9748.53593977) OR
  30.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '1f93aa08cdc37b6d5b84c616f5f6f2e7' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4694.17946632) OR
  31.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '1fa2b1a6c7a3a71bcaa54770e859fdef' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2885.79494118) OR
  32.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '229b825aa52183456bc67e6ce5cef5bb' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2813.34740615) OR
  33.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '22b5e7a5f062d50c610ecbc70471b2a2' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 14133.57511051) OR
  34.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '233904678ee27735d956379fcd243ac7' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5207.58255817) OR
  35.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '2363f9eaa7d7c6af907322952355398e' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4748.98982331) OR
  36.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '23f38c0cb10bbce92710c634ecf4c35c' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3253.94493033) OR
  37.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '272c9fd8ad0d1773e5a632eb2635edca' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2811.02315509) OR
  38.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '279f96d5e50349ff8ee0d30278c62995' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 1367.30496073) OR
  39.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '27c5f7537d1ead0fd20453db8166efad' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4725.02257608) OR
  40.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '2c9738a0583b28e39cb9d187602a36ad' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4411.10677393) OR
  41.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '2dfc3b8539a9945ea3219f3fdaffa2f7' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2885.31502364) OR
  42.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '2f7d3e799fa47a14243b1193a8037e41' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4081.51469894) OR
  43.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '3385334b46291be2262e23a564e2f1f7' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2244.18205053) OR
  44.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '34740a338bf0e352548bf2c3e2c05952' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2811.02315509) OR
  45.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '37004ddb844031ebcabfe371550025b0' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 8630.53594847) OR
  46.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '375317c89acffe486ffc22986014d2af' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4017.93002033) OR
  47.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '37e501f6dcabafa87f62e79b0c2c340d' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4642.59355409) OR
  48.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '3881109311174eb50dcad6b83f842b41' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 11224.60254779) OR
  49.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '39bc2df421b5d8352114fdaf5d9b7c5d' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3606.29103833) OR
  50.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '39cc1505795cae1d1241830b8a6273b2' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4713.29359431) OR
  51.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '3b9c7a445838593db6aef2cbf4bf2186' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2643.10953088) OR
  52.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '3cf166dd93b8e683df36297e961483aa' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4207.79116578) OR
  53.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '3fe75f9756f5a7549b7629c93e5f4da8' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4092.49497151) OR
  54.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '40f4d6f70e8a1df989816ca9f82001f0' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 7149.37523418) OR
  55.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '41cad7e1d2a6355268a7e0bc0c7d39dc' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2006.47019774) OR
  56.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '44d1903842bc1b539465a225b0828c94' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4058.41394148) OR
  57.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '45c48cce2e2d7fbdea1afc51c7c6ad26' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 1206.83907134) OR
  58.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '4957ed03f1052277a03574561ec0026d' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3120.45343841) OR
  59.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '4b68528709f2f77c2bb1570d9084bb51' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 6173.77060536) OR
  60.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '4cd88c8604475f1f9c151eefaccc4986' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5725.5071701) OR
  61.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '5060a1037e2a6d0a1575da0f4b98f628' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4064.30114082) OR
  62.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '52f2b56a25ba945acbf6e9d4bc05d838' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5048.2834013) OR
  63.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '58c14442337f87e439b20578a8dc51b9' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4787.91039567) OR
  64.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '61091770b7fa2da6975baffd783c4f1d' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4580.11966727) OR
  65.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6202042f4ac4be2bcf37c7645643851c' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4477.04377166) OR
  66.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '631426625ebcb2742ce89c40d3e6b63a' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2745.83668946) OR
  67.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6512bd43d9caa6e02c990b0a82652dca' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3935.95322363) OR
  68.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '66beecd8fdf64e7e3e7461527cc66b18' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5163.51634852) OR
  69.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6786f525adafd48ea3946a0079b601f8' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5079.05710513) OR
  70.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6a3289b79cdb7759bd999db57af5612a' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2811.02315509) OR
  71.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6a38c85efcab5e99cd1f971cdeba3e4a' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3172.37990673) OR
  72.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6adc075f003c416a74b5db87f7bcc091' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4546.03053141) OR
  73.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6b73b55ad53309fd0d6f4a1f3cf022ba' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4993.65387854) OR
  74.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6c120edb0f251e21e6a17fe5c13a508b' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5143.14025826) OR
  75.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6c186b37740199c7ccd71a52dd9dae4b' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 6337.79429796) OR
  76.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6c640ab89f18b82f65cb691d28b10ab8' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4452.4417808) OR
  77.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6d8a45049c2a4700d7083df39800e148' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3935.95322363) OR
  78.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6f4922f45568161a8cdf4ad2299f6d23' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5526.10228892) OR
  79.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '6f918edea4348ab2cd12f5b3b4e87dea' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4993.65387854) OR
  80.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '703162c61a3cf65b0d57fae90eeb694c' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 9001.88787865) OR
  81.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '757cb6790f8afd43f23e5c09ba9784f8' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 11113.89712778) OR
  82.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '76a9260590f3ddab29aa0bf632da2a53' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4231.99263177) OR
  83.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '77bced46da0535d77b167df61b2e9a4e' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2885.79494118) OR
  84.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '799f91edae3e011fdeac50bf47b0b040' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5269.12312084) OR
  85.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '7c6deb01af22c5b25410310277dcd902' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4254.6032037) OR
  86.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '7ce66e4e7cdd2a1623ace2f55fafdb02' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5440.08727065) OR
  87.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '7dbe2bb8f7ae8bd677a1f171f4bd91bf' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3029.99390895) OR
  88.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '813f4821286f36d52c8efccd6ed00f95' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 1124.74754305) OR
  89.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '8313b80042301963288ce541ccf6f47d' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5293.96427993) OR
  90.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '8c3014e49b2e9f79470cc6030cb2df38' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3900.58304617) OR
  91.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '8f14e45fceea167a5a36dedd4bea2543' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2346.56649223) OR
  92.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '904115354e8da20f9ba8a4ac6896151c' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 1340.062395) OR
  93.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '935bb5526f414ff80320fa218f25f8c0' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3935.95322363) OR
  94.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '94e0fd5e9194505e233275272a19c796' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 7170.98201082) OR
  95.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '97a5ae538b8ce2a5bee19d3e371406b5' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 8512.77641698) OR
  96.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '98f73e75837aa0baa4a6294d1e5f0a4b' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4591.8911286) OR
  97.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '98f8f592ca6c35a92c334fae5c0c3143' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4207.79116578) OR
  98.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '98f9aed970aad563a992d9fa57caedd1' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4678.46965878) OR
  99.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '9b134154975b3ee60e86f2376a8ffc44' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 8904.08273285) OR
  100.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '9bf31c7ff062936a96d3c8bd1f8f2ff3' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 1939.25464791) OR
  101.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '9dd88d411ebc01ddf7edbbf5bcb19ebf' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3127.86621437) OR
  102.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = '9f3e9965531e088477bbcb0208127f52' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5444.89496658) OR
  103.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'a0d98f919e8e54ea4254adb2579039fc' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4084.65733012) OR
  104.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'a37f5aa3ca64a6f0f0011954964f2709' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 6216.75270027) OR
  105.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'a495d65d702cc653d642f2d0163d58cb' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4725.08019284) OR
  106.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'a4ad59a73bca3462e21edecba72b8adb' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5021.07179345) OR
  107.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'a51e3a2f8905340318dba79795a7a5fc' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4636.75158872) OR
  108.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'a5dd97e4daa480b19f84836c7d396aee' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2957.13918764) OR
  109.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'a87ff679a2f3e71d9181a67b7542122c' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5343.84644515) OR
  110.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'aab3238922bcc25a6f606eb525ffdc56' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 6850.71743978) OR
  111.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'abd22e906426a453d9f5e6df247416f0' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3221.55461635) OR
  112.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'b5a617d996fafe762b2865b59a9018c2' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4017.93002033) OR
  113.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'b6571fc8d8eb255c9fe7ded2040388d4' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4532.34122787) OR
  114.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'b75ebd00fad396363fa3782835d3b583' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5716.84177657) OR
  115.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'b7a0e95a2591b8a780cf86ee1383a8ad' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4870.77523949) OR
  116.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'b8d355655cb4328fd4021afa2e946442' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4318.9266368) OR
  117.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'b8db15a90e9e66fcc78d1c540b85ca31' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 9639.23336538) OR
  118.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'b929b57c62b61629d0c493bd91902da4' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4207.79116578) OR
  119.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'bd7938e91834d4c81398c7fbfe846aed' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4800.99335276) OR
  120.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'be7a643f5d83c027a14b69aa20aacb49' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5711.56720866) OR
  121.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'c04202d681460b7f3a6b4b848bf1b639' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4231.99263177) OR
  122.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'c145b7fc648106c5b5b9d712c091c2dd' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5143.14025826) OR
  123.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'c20ad4d76fe97759aa27a0c99bff6710' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4231.99263177) OR
  124.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'c4ca4238a0b923820dcc509a6f75849b' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4030.12600287) OR
  125.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'c51ce410c124a10e0db5e4b97fc2af39' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4231.99263177) OR
  126.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'c81e728d9d4c2f636f067f89cc14862c' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4725.02257608) OR
  127.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'c8f5b04234c069c294cf3e146e32dad5' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5024.12963295) OR
  128.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'ca412c5f69d2cb060032ff99aa243901' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4607.01420596) OR
  129.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'cbb83895c1926dee3a07a0f6351896b9' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3127.86621437) OR
  130.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'cf96e2aebf763da37f61a147508a4e10' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4634.78062544) OR
  131.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'd09a4ca49e56d17af80f9b1909f9e21c' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4680.7256507) OR
  132.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'd2cdac78563f61eb5f9041ad4c89347c' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5860.11582783) OR
  133.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'd47167b7a41f58bbc5911aef46dc2655' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5523.84706775) OR
  134.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'd62950ca0b437a2337450f8e9c79d2da' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2378.40813159) OR
  135.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'd911903c46195647705d884ee97eb663' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4231.99263177) OR
  136.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'd93e1ba041250842fa3227dddc400625' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4782.27901263) OR
  137.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'db481912d74e76065e16d8b3cd0a4f2a' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4993.65387854) OR
  138.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'de4a042c81f00bcc4733fb1f6a563fb9' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2538.29474403) OR
  139.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e04556ff5bee8f395a6ad0b92521b532' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4457.9972511) OR
  140.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e0ae0e0d52deb95626382444fa049f8d' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4193.26225714) OR
  141.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e188281ab9bf21b896c697b88d9cb5a9' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3982.21529508) OR
  142.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e1d06f90aeecb889e393f4fa9fb9d081' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3127.86621437) OR
  143.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e3429bc9ef1478d388825df06671fd71' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4332.98305622) OR
  144.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e47d47c555c98685bf4154ec8043c271' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5225.42119596) OR
  145.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e4da3b7fbbce2345d7772b0674a318d5' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 1605.05233665) OR
  146.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e536c4e3ad6aa4c1bf128d09dc7238b3' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 10093.82873701) OR
  147.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e6b355df47b5e7a1fafe6a677e0bb022' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 9591.4538692) OR
  148.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e6b3d88bb4c1a4651ff25f6a98d7843a' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 7841.37863568) OR
  149.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'e7aa8651f39c643f45ae1ce5fd5f9e93' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 3341.21078335) OR
  150.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'eb93ab205b1bb7924edd3829aad358f8' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4582.98766904) OR
  151.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'ebc438b9c8f65000b183dc14caa054b5' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 9131.95262398) OR
  152.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'eccbc87e4b5ce2fe28308fd9f2a7baf3' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2548.38772472) OR
  153.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'ecd9d86d2d588014800678fb7a99bad8' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4017.41250047) OR
  154.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'ef27c89e4803427e44e3ccd294cb03e9' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 10507.24381336) OR
  155.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'f198d65a112273ea2a4f06f7fdff5bcb' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2320.55443786) OR
  156.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'f4dd0a9076efa7f5aa4f9ffa5aeed11e' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 2885.79494118) OR
  157.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'f645cbe4606c79510dd768a174840f95' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5269.12312084) OR
  158.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'f7c53c619cd167c2c2743ce62c03b6b1' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5716.84177657) OR
  159.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'f7dbedbbb01181e8809406ea783b8c0e' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4835.82105147) OR
  160.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'f8014dd33d192eb12904ee473ebecc34' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5101.92529263) OR
  161.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'f84b1ca234c965939eda6ea837adc6ae' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4231.99263177) OR
  162.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'f8e1b3a8a1166bc6da83b916cfd31dc9' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5095.10059834) OR
  163.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'f98767e852b49a1c82bb6d60438cbb9f' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5124.07808523) OR
  164.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'fa431909250dc776017329891204ccdc' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4576.93047262) OR
  165.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'fb210172dc5ea3d7e9d3ad287766bcb3' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4278.42650648) OR
  166.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'fc7a629921d2bbf465a2a5828b54fffe' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4799.09631394) OR
  167.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'fdd9869adb5dff65e0dbd941b75897b7' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 5348.07602327) OR
  168.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'fe634c2e57ca10d8a39a56b90ce5e2ff' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 8231.59039143) OR
  169.     (MD5(COALESCE(CAST(r13_.network_id AS text), r13_.email)) = 'ff71a9d565ab99a16e186c52dc70f581' AND ST_Distance(r22_.geolocation, ST_Point(27.592419, 53.936439), true) = 4084.65733012))
  170.     ) AND (r13_.enabled = '1') AND (r13_.in_sync is not false))) AND (r0_.enabled = '1') AND (r0_.in_sync is not false) ORDER BY sclr_1 ASC, sclr_3 ASC, r0_.id ASC LIMIT 30;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!