API tools faq
paste
Guest User

Untitled

a guest
Aug 26th, 2016
61
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.63 KB | None | 0 0
raw download clone embed print report
  1. SELECT DISTINCT ON ("routes_route"."id") "routes_route"."id", "routes_route"."car_id", "routes_route"."name",
  2. "routes_route"."route_type", "routes_route"."route_fixed_type", "routes_route"."route_days",
  3. "routes_route"."route_time_start", "routes_route"."route_time_end", "routes_route"."route_time_back_start",
  4. "routes_route"."route_time_back_end", "routes_route"."comment", "routes_route"."km", "routes_route"."yandex_path",
  5. "routes_route"."back_path_start_point", "routes_route"."area_locality_id", "routes_route"."deleted",
  6. ST_Distance_Sphere("routes_route"."yandex_path", ST_GeomFromEWKB('\001\001\000\000
  7. \346\020\000\000vq\033\015\340A>@\251\333\331W\036\360M@'::bytea)) AS "dst", "base_car"."id", "base_car"."driver_id",
  8. "base_car"."type", "base_car"."usage_type", "base_car"."rating_id", "base_car"."car_model_id", "base_car"."year",
  9. "base_car"."color", "base_car"."photo", "base_car"."activity_taxi", "base_car"."activity_delivery",
  10. "base_car"."activity_cargo", "base_car"."car_number", "base_car"."deleted", "base_car"."ready_for_work",
  11. "base_car"."admin_rating", "base_car"."final_rating", "base_car"."always_unlocked", "base_car"."view_count",
  12. "base_car"."similarity" FROM "routes_route" INNER JOIN "base_car" ON ("routes_route"."car_id" = "base_car"."id") INNER
  13. JOIN "advertising_brandingadvinfo" ON ("base_car"."id" = "advertising_brandingadvinfo"."car_id") INNER JOIN
  14. "account_driver" ON ("base_car"."driver_id" = "account_driver"."id") LEFT OUTER JOIN "routes_route_district_localities"
  15. ON ("routes_route"."id" = "routes_route_district_localities"."route_id") WHERE ("base_car"."deleted" = False AND
  16. "routes_route"."deleted" = False AND NOT ("advertising_brandingadvinfo"."id" IS NULL) AND NOT
  17. ("base_car"."ready_for_work" = False) AND ("advertising_brandingadvinfo"."date_to"::date -
  18. "advertising_brandingadvinfo"."date_from"::date >= 30 OR "advertising_brandingadvinfo"."date_do_not_care") AND
  19. "base_car"."type" IN (auto, bus, track_less, track_more) AND "account_driver"."city_id" = 1 AND
  20. "advertising_brandingadvinfo"."id" IN (162, 164, 177, 178, 179, 180, 181, 182, 1667, 185, 186, 1657, 188, 1676, 190,
  21. 191, 192, 193, 1685, 195, 196, 197, 198, 199, 200, 201, 202, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 215, 216,
  22. 217, 218, 219, 220, 221, 222, 224, 225, 227, 228, 229, 230, 231, 232, 233, 234, 237, 238, 240, 241, 242, 243, 245, 247,
  23. 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 102, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114,
  24. 115, 116, 118, 119, 120, 121, 122, 123, 126, 127, 128, 129, 131, 132, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143,
  25. 144, 145, 146, 147, 150, 151, 152, 153, 155, 156, 157, 158, 159, 160, 161, 165, 166, 167, 168, 169, 170, 172, 173, 174,
  26. 175, 176, 261, 262, 263, 264, 266, 267, 268, 269, 270, 271, 272, 273, 275, 276, 277, 278, 280, 281, 282, 283, 284, 285,
  27. 287, 288, 289, 290, 291, 292, 293, 294, 1659, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310,
  28. 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 327, 328, 1677, 330, 331, 332, 333, 334, 335,
  29. 337, 1686, 339, 340, 341, 342, 343, 344, 345, 347, 348, 349, 350, 351, 353, 354, 356, 358, 359, 360, 361, 362, 363, 364,
  30. 365, 366, 367, 368, 370, 371, 372, 373, 374, 375, 376, 377, 378, 380, 381, 382, 384, 386, 387, 388, 389, 390, 392, 394,
  31. 395, 396, 398, 399, 401, 402, 403, 404, 406, 407, 408, 409, 410, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422,
  32. 423, 424, 425, 428, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 446, 447, 450, 452, 453, 454,
  33. 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 1660, 471, 472, 473, 474, 475, 477, 478, 479,
  34. 480, 481, 482, 484, 485, 486, 487, 488, 489, 490, 491, 1669, 493, 494, 495, 496, 499, 500, 501, 502, 503, 1678, 505,
  35. 506, 507, 508, 509, 510, 511, 512, 1687, 514, 515, 516, 518, 519, 520, 521, 522, 524, 525, 526, 527, 529, 530, 531, 532,
  36. 533, 535, 536, 537, 538, 539, 540, 542, 543, 544, 547, 549, 550, 551, 552, 553, 555, 557, 558, 559, 561, 562, 565, 566,
  37. 567, 568, 569, 570, 572, 573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591,
  38. 592, 593, 594, 595, 596, 597, 598, 599, 600, 601, 602, 603, 604, 605, 606, 607, 608, 610, 611, 612, 613, 614, 615, 616,
  39. 617, 619, 620, 621, 622, 623, 624, 626, 627, 628, 629, 630, 631, 632, 635, 636, 637, 638, 639, 641, 643, 644, 645, 646,
  40. 647, 648, 649, 650, 651, 652, 654, 655, 657, 658, 659, 661, 662, 663, 664, 665, 666, 667, 668, 669, 670, 671, 672, 674,
  41. 675, 676, 677, 678, 1670, 680, 681, 683, 684, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 698, 700,
  42. 701, 702, 703, 704, 705, 706, 707, 708, 1688, 711, 712, 713, 715, 717, 718, 719, 720, 721, 722, 723, 724, 725, 726, 727,
  43. 728, 729, 730, 731, 732, 733, 735, 736, 737, 739, 740, 742, 743, 744, 745, 747, 748, 749, 750, 751, 753, 754, 755, 756,
  44. 757, 758, 759, 760, 762, 764, 765, 766, 767, 768, 769, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784,
  45. 785, 786, 787, 789, 790, 791, 792, 793, 794, 796, 797, 798, 799, 800, 801, 802, 803, 805, 806, 807, 808, 809, 812, 813,
  46. 814, 815, 816, 817, 818, 819, 820, 823, 824, 825, 826, 827, 828, 830, 831, 832, 833, 834, 835, 836, 838, 839, 840, 841,
  47. 842, 843, 844, 845, 847, 848, 849, 850, 851, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868,
  48. 869, 870, 871, 872, 873, 874, 875, 1671, 878, 879, 880, 881, 882, 883, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893,
  49. 894, 896, 897, 900, 901, 902, 903, 904, 905, 906, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 921, 922, 923,
  50. 924, 927, 929, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952,
  51. 953, 954, 957, 958, 960, 961, 962, 963, 964, 965, 966, 967, 968, 969, 970, 971, 972, 973, 974, 975, 976, 977, 978, 979,
  52. 980, 981, 983, 984, 985, 987, 988, 989, 990, 991, 992, 993, 994, 996, 997, 998, 999, 1000, 1002, 1004, 1005, 1006, 1007,
  53. 1008, 1009, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1019, 1020, 1021, 1022, 1024, 1025, 1026, 1027, 1028, 1030, 1031,
  54. 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1663, 1044, 1045, 1047, 1048, 1049, 1050, 1051, 1052, 1672,
  55. 1054, 1055, 1681, 1057, 1058, 1059, 1060, 1062, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075,
  56. 1076, 1077, 1078, 1079, 1080, 1083, 1084, 1085, 1086, 1088, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1099, 1101, 1102,
  57. 1103, 1104, 1105, 1106, 1107, 1109, 1110, 1111, 1112, 1113, 1114, 1116, 1117, 1118, 1120, 1121, 1122, 1125, 1126, 1127,
  58. 1129, 1130, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1141, 1142, 1143, 1144, 1145, 1146, 1148, 1149, 1150, 1151,
  59. 1152, 1153, 1154, 1155, 1156, 1157, 1158, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1169, 1170, 1172, 1173, 1174,
  60. 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1186, 1187, 1188, 1191, 1192, 1193, 1194, 1195, 1196, 1198,
  61. 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1208, 1209, 1211, 1664, 1214, 1215, 1216, 1218, 1219, 1220, 1221, 1222,
  62. 1223, 1225, 1226, 1673, 1229, 1231, 1234, 1235, 1236, 1237, 1238, 1239, 1242, 1245, 1246, 1247, 1248, 1249, 1250, 1252,
  63. 1253, 1254, 1255, 1256, 1258, 1259, 1261, 1262, 1263, 1264, 1265, 1266, 1267, 1268, 1269, 1270, 1271, 1272, 1273, 1274,
  64. 1275, 1276, 1277, 1278, 1279, 1280, 1281, 1282, 1283, 1284, 1286, 1287, 1289, 1290, 1292, 1293, 1294, 1295, 1296, 1297,
  65. 1298, 1300, 1301, 1302, 1304, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1317, 1318, 1319, 1320,
  66. 1321, 1322, 1323, 1325, 1326, 1327, 1329, 1330, 1331, 1332, 1333, 1334, 1335, 1337, 1338, 1339, 1340, 1341, 1342, 1343,
  67. 1344, 1345, 1347, 1348, 1349, 1350, 1351, 1352, 1353, 1354, 1355, 1356, 1357, 1358, 1359, 1360, 1361, 1362, 1363, 1364,
  68. 1365, 1366, 1367, 1368, 1370, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1379, 1381, 1382, 1383, 1384, 1386, 1387,
  69. 1388, 1389, 1390, 1391, 1392, 1393, 1394, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1404, 1406, 1407, 1409,
  70. 1410, 1411, 1412, 1413, 1414, 1415, 1416, 1417, 1418, 1419, 1420, 1421, 1422, 1423, 1424, 1425, 1426, 1427, 1428, 1429,
  71. 1430, 1665, 1433, 1434, 1674, 1437, 1438, 1439, 1440, 1441, 1442, 1443, 1444, 1445, 1446, 1447, 1450, 1451, 1452, 1453,
  72. 1454, 1456, 1457, 1458, 1461, 1462, 1463, 1466, 1467, 1468, 1469, 1470, 1471, 1472, 1473, 1474, 1475, 1476, 1478, 1480,
  73. 1481, 1482, 1483, 1484, 1485, 1486, 1487, 1488, 1489, 1491, 1492, 1493, 1494, 1495, 1496, 1497, 1498, 1499, 1500, 1501,
  74. 1502, 1504, 1506, 1508, 1509, 1510, 1511, 1512, 1515, 1517, 1518, 1520, 1521, 1522, 1523, 1525, 1526, 1527, 1528, 1529,
  75. 1531, 1533, 1535, 1536, 1537, 1538, 1539, 1540, 1541, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1553, 1554,
  76. 1555, 1556, 1557, 1558, 1560, 1561, 1562, 1563, 1564, 1565, 1566, 1567, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575,
  77. 1576, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1586, 1587, 1588, 1589, 1590, 1591, 1594, 1595, 1596, 1597, 1599,
  78. 1655, 1652, 1647, 1638, 1648, 1637, 1666, 1614, 1642, 1653, 1656, 1644, 1675, 1684, 1651, 1608, 1632, 1645) AND
  79. (("routes_route"."route_type" = line AND ST_Distance_Sphere("routes_route"."yandex_path",
  80. ST_GeomFromEWKB('\001\001\000\000 \346\020\000\000vq\033\015\340A>@\251\333\331W\036\360M@'::bytea)) <= 300.0) OR
  81. ("routes_route"."route_type" = circle AND "routes_route_district_localities"."locality_id" IN (5)) OR
  82. ("routes_route"."route_type" = random AND "routes_route"."area_locality_id" IN (SELECT U0."id" FROM "geo_locality" U0
  83. INNER JOIN "geo_geoobject" U1 ON (U0."geo_object_id" = U1."id") WHERE (ST_Intersects(U1."multipolygon",
  84. ST_GeomFromEWKB('\001\001\000\000 \346\020\000\000vq\033\015\340A>@\251\333\331W\036\360M@'::bytea)) AND
  85. U0."locality_type" = area))))) ORDER BY "routes_route"."id" ASC
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!