array(13) {
  ["stars_from"]=>
  NULL
  ["stars_to"]=>
  NULL
  ["stars_array"]=>
  array(2) {
    [0]=>
    int(7)
    [1]=>
    int(9)
  }
  ["evaluation"]=>
  int(0)
  ["view"]=>
  string(4) "grid"
  ["destinations"]=>
  array(1) {
    [0]=>
    int(16)
  }
  ["destinationmulti"]=>
  array(0) {
  }
  ["region"]=>
  int(0)
  ["limit_start"]=>
  int(2)
  ["stars_in_array"]=>
  array(4) {
    [0]=>
    int(7)
    [1]=>
    int(9)
    [2]=>
    int(8)
    [3]=>
    int(10)
  }
  ["hotel_reconstruction_ids"]=>
  array(11) {
    [0]=>
    int(68)
    [1]=>
    int(436)
    [2]=>
    int(493)
    [3]=>
    int(1085)
    [4]=>
    int(1673)
    [5]=>
    int(68)
    [6]=>
    int(436)
    [7]=>
    int(493)
    [8]=>
    int(1035)
    [9]=>
    int(1085)
    [10]=>
    int(1673)
  }
  ["state"]=>
  int(1)
  ["is_mobile"]=>
  bool(false)
}
SELECT DISTINCT h.id, h.*, d.name as destination_name, mh.`region`, mh.`region_id`, mh.`group_id`,
mh.`place`, mh.lowest_food, mh.lowest_price, mh.evaluation, mh.evaluation_count, mhdg.from as
gd_from, mhdg.to as gd_to, mhdg.amount as gd_amount, mhda.days as discount_advance_days,
mhda.min_nights as discount_advance_min_nights,mhda.amount as discount_advance_amount,
mhdfn.required as discount_free_nights_required, mhdfn.free as discount_free_nights_free,
mhds.required as discount_senior_required, mhds.amount as discount_senior_amount, mhdfnt.required as
discount_free_nights_two_required, mhdfnt.amount as discount_free_nights_two_amount, tip_1 , tip_2 ,
tip_3 
FROM `mod_hotel_hotel` AS `h` JOIN `mauc_list_hotel` AS `mh` ON h.mauc_id = mh.id JOIN
`mod_destination_destination` AS `d` ON h.parent = d.id 
LEFT JOIN `mauc_list_hotel_food` AS `mhf` ON h.mauc_id = mhf.id_hotel 
LEFT JOIN `mauc_list_hotel_discount_global` AS `mhdg` ON h.mauc_id = mhdg.id_hotel 
LEFT JOIN `mauc_list_hotel_discount_advance` AS `mhda` ON h.mauc_id = mhda.id_hotel 
LEFT JOIN `mauc_list_hotel_discount_free_nights` AS `mhdfn` ON h.mauc_id = mhdfn.id_hotel 
LEFT JOIN `mauc_list_hotel_discount_free_nights_two` AS `mhdfnt` ON h.mauc_id = mhdfnt.id_hotel 
LEFT JOIN `mauc_list_hotel_discount_senior` AS `mhds` ON h.mauc_id = mhds.id_hotel 
WHERE h.parent IN ( 16 ) AND h.state = 1 AND h.not_recommended != 1 AND h.stars IN ( 7, 8, 9, 10 )
AND h.state != 5 
ORDER BY FIELD( h.`mauc_id`, 421, 1723, 849, 977, 311, 162, 329, 255, 303, 56, 315, 38, 171, 316,
781, 328, 322, 486, 732, 51, 36, 61, 64, 324, 60, 43, 37, 53, 638, 69, 66, 59, 62, 63, 1000, 42, 45,
96, 49, 533, 326, 1065, 433, 325, 327, 1212, 450, 451, 452, 455, 503, 532, 456, 758, 1679, 186, 423,
44, 47, 65, 67, 323, 418, 55, 802, 435, 1029, 989, 1182, 1368, 1563, 627, 1564, 497, 788, 866, 879,
880, 950, 1126, 52, 1242, 1610, 1630, 1640, 1680, 1683, 1684, 41, 95, 46, 50, 1407, 70, 71, 605,
898, 208, 874, 606, 876, 73, 75, 76, 77, 78, 79, 80, 81, 83, 85, 87, 89, 90, 92, 91, 607, 647, 648,
681, 682, 994, 1408, 1409, 1414, 1415, 1523, 241, 1646, 1647, 74, 214, 191, 190, 276, 135, 237, 132,
141, 142, 133, 137, 138, 139, 136, 140, 127, 239, 144, 145, 238, 242, 243, 308, 309, 310, 313, 531,
618, 656, 657, 658, 1044, 134, 143, 299, 617, 1385, 1386, 1543, 97, 1573, 602, 750, 1487, 1530,
1531, 1532, 99, 147, 398, 120, 108, 943, 159, 425, 427, 603, 818, 169, 103, 123, 172, 121, 305, 183,
178, 113, 1042, 628, 808, 104, 110, 122, 105, 124, 158, 125, 173, 107, 118, 156, 170, 164, 176, 177,
180, 306, 181, 424, 126, 623, 146, 640, 160, 1133, 1338, 767, 1348, 768, 1637, 1666, 769, 1746, 179,
770, 819, 882, 119, 881, 102, 157, 101, 1033, 106, 112, 114, 163, 161, 174, 235, 944, 1420, 654,
1758, 297, 655, 737, 1327, 128, 428, 1196, 609, 360, 454, 765, 426, 738, 397, 168, 1174, 439, 240,
231, 165, 185, 199, 196, 966, 131, 200, 434, 232, 254, 187, 822, 496, 895, 947, 985, 987, 1031, 902,
905, 1041, 906, 1147, 1129, 1119, 1168, 1192, 1194, 129, 1197, 1283, 167, 1301, 766, 1310, 197, 831,
1322, 1332, 772, 1342, 1356, 1343, 1400, 1491, 438, 1496, 519, 1535, 228, 1550, 1623, 252, 1643,
1688, 253, 1689, 1715, 429, 1718, 166, 1722, 1727, 1751, 848, 780, 149, 182, 744, 207, 227, 518,
198, 195, 201, 320, 727, 626, 524, 396, 394, 395, 430, 431, 619, 361, 925, 976, 1066, 1088, 1138,
756, 1127, 1151, 1188, 1286, 796, 992, 757, 1346, 1403, 1405, 1577, 1670, 1712, 1222, 1223, 1309,
1340, 1344, 1398, 1399, 1401, 1402, 1404, 1503, 1633, 1634, 213, 400, 401, 402, 403, 404, 405, 406,
407, 408, 409, 410, 411, 678, 679, 721, 389, 387, 1763, 516, 441, 384, 383, 599, 525, 386, 448, 445,
440, 510, 554, 507, 379, 388, 444, 509, 512, 513, 514, 515, 517, 511, 523, 526, 527, 528, 529, 530,
598, 600, 680, 861, 862, 863, 864, 865, 958, 1030, 1057, 1061, 1074, 1075, 1076, 1096, 378, 382,
390, 399, 443, 446, 447, 449, 508, 722, 760, 762, 763, 764, 776, 778, 779, 845, 846, 847, 889, 955,
956, 957, 959, 1139, 1227, 1277, 1453, 1466, 1473, 1538, 1549, 1551, 1554, 1557, 1644, 347, 348,
352, 359, 432, 502, 504, 505, 506, 520, 536, 537, 538, 539, 540, 541, 542, 543, 544, 689, 545, 546,
547, 548, 549, 550, 551, 552, 392, 553, 130, 610, 624, 734, 735, 771, 814, 817, 1063, 1611, 244,
380, 804, 381, 803, 688, 792, 1190, 1302, 1300, 1305, 967, 1208, 969, 1290, 415, 414, 1320, 988,
1287, 1189, 918, 1077, 1225, 412, 413, 805, 1014, 1092, 1093, 393, 1224, 1234, 691, 1285, 1291,
1296, 1297, 1321, 1351, 1352, 1416, 1417, 1419, 1522, 1544, 1574, 1587, 1617, 1618, 1622, 1636,
1642, 1693, 1705, 1739, 1745, 1747, 417, 1209, 1219, 1171, 391, 1211, 1249, 1276, 793, 1299, 1341,
1418, 1464, 1467, 1468, 1469, 1470, 1481, 1482, 1539, 1540, 1548, 1676, 1677, 1686, 1696, 1762,
1765, 247, 1462, 1054, 1091, 1375, 1376, 1519, 1536, 1537, 1602, 1603, 1729, 1732, 1734, 625, 148,
152, 690, 1396, 1360, 1685, 1743, 1671, 1641, 1585, 1672, 1663, 1361, 1588, 1604, 1524, 1484, 1542,
1365, 1364, 150, 1509, 1339, 1337, 1363, 1345, 613, 1362, 1457, 1471, 1502, 1578, 1632, 1754, 153,
154, 155, 184, 203, 206, 594, 694, 695, 696, 697, 801, 1201, 1492, 1202, 1203, 1303, 1304, 1308,
1314, 1317, 1319, 1324, 1326, 1325, 1334, 1335, 1353, 1366, 1381, 1382, 1383, 1397, 791, 1499, 1541,
1575, 1605, 192, 193, 212, 226, 249, 250, 251, 205, 210, 211, 293, 718, 719, 720, 225, 258, 222,
221, 1184, 262, 263, 259, 365, 261, 217, 364, 366, 224, 312, 220, 216, 223, 260, 363, 219, 362, 215,
265, 535, 555, 556, 615, 639, 641, 749, 1017, 1018, 1073, 1116, 1117, 1118, 1120, 563, 1121, 1122,
1215, 1279, 1371, 1493, 1525, 1526, 1527, 1594, 1595, 1612, 1614, 1615, 1616, 1620, 1626, 1674,
1757, 1067, 1068, 1069, 1070, 1078, 369, 334, 367, 335, 321, 368, 374, 589, 665, 666, 667, 668, 669,
670, 671, 672, 673, 674, 675, 676, 677, 740, 746, 747, 748, 753, 754, 755, 832, 884, 885, 1013,
1280, 330, 1281, 331, 1472, 333, 1558, 1559, 1560, 1579, 1580, 1162, 1581, 1759, 1760, 717, 419,
1010, 564, 1038, 565, 752, 1329, 1330, 1022, 1011, 1198, 420, 711, 712, 713, 714, 621, 715, 751,
789, 1008, 1071, 723, 759, 1336, 1354, 1567, 1664, 742, 826, 246, 741, 790, 823, 824, 825, 827, 828,
829, 830, 915, 890, 1009, 1016, 932, 1072, 945, 1163, 1200, 416, 1213, 965, 151, 1214, 938, 1289,
1318, 708, 709, 996, 710, 998, 716, 795, 1389, 1390, 557, 1048, 1391, 1392, 1463, 1480, 1159, 1596,
1613, 338, 1678, 1150, 1740, 257, 332, 339, 336, 337, 340, 341, 1170, 342, 343, 344, 1178, 346, 561,
1179, 372, 1180, 521, 558, 567, 559, 560, 562, 566, 568, 569, 570, 574, 571, 575, 572, 573, 576,
577, 591, 596, 1370, 597, 620, 622, 629, 644, 660, 659, 661, 663, 664, 745, 761, 784, 782, 806, 783,
807, 786, 820, 787, 904, 798, 914, 916, 937, 812, 949, 815, 971, 972, 833, 984, 997, 875, 999, 1005,
907, 1007, 1012, 917, 1015, 1079, 919, 1064, 1158, 946, 1152, 948, 1135, 1128, 1090, 1143, 1193,
1204, 1206, 1004, 1226, 1292, 1295, 1298, 1316, 1055, 1323, 1355, 1160, 1374, 1377, 1406, 1136,
1137, 1333, 1423, 1424, 1425, 1426, 1161, 1427, 1169, 1428, 1175, 1429, 1177, 1430, 1183, 1497,
1518, 1199, 1521, 1545, 1572, 1210, 1586, 1590, 1698, 1704, 1716, 1306, 1730, 1741, 1753, 1761,
1191, 1372, 1576, 1631, 1384, 1432, 1433, 1421, 1667, 1422, 1675, 1719, 1733, 1086, 1735, 1087,
1737, 1752, 302, 1653, 1650, 1598, 1651, 275, 1475, 1027, 266, 1504, 288, 267, 268, 269, 1566, 272,
274, 278, 1589, 279, 285, 1619, 286, 1695, 287, 289, 291, 294, 692, 1039, 270, 271, 290, 295, 1454,
1455, 1485, 1486, 1488, 1489, 1546, 1388, 1648, 1649, 1661, 292, 1207, 583, 968, 739, 350, 351, 353,
354, 355, 356, 357, 358, 349, 578, 579, 580, 581, 582, 584, 585, 586, 587, 645, 650, 652, 653, 651,
649, 883, 886, 951, 1001, 1002, 1034, 1062, 1278, 1591, 1687, 1691, 1717, 1728, 646, 809, 926, 927,
928, 929, 934, 935, 936, 990, 991, 1003, 1431, 1627, 1628, 1738, 1744, 840, 841, 842, 843, 844, 851,
852, 853, 854, 855, 856, 857, 858, 859, 860, 973, 974, 975, 1652, 1261, 1263, 1517, 1556, 1561,
1724, 1742, 1260, 1270, 1272, 1328, 1331, 1624, 1660, 743, 877, 1148, 1149, 1130, 1220, 1256, 1176,
1259, 1358, 1520, 962, 1233, 1232, 878, 963, 964, 1006, 961, 960, 1235, 1236, 1237, 1238, 1239,
1240, 1241, 1257, 1258, 1262, 1264, 1265, 1269, 1275, 1282, 1315, 1349, 1357, 1359, 1367, 1607,
1609, 588, 592, 593, 608, 611, 698, 699, 700, 701, 702, 703, 704, 705, 706, 707, 799, 800, 810, 811,
837, 838, 887, 888, 979, 980, 1131, 1132, 1692, 1694, 483, 461, 465, 457, 458, 459, 462, 463, 464,
460, 616, 901, 1080, 1081, 1154, 1155, 1165, 1166, 1173, 1195, 1458, 1459, 1460, 1461, 1528, 1529,
1601, 1713, 1725, 1748, 1756, 1266, 1267, 1268, 1271, 1273, 1274, 1393, 1394, 1395, 1625, 1638,
1639, 1654, 1655, 1656, 1657, 1658, 1659, 1681, 1714, 1056, 1060, 1141, 1142, 1144, 1145, 1205,
1216, 1217, 1228, 1252, 1254, 1347, 1562, 1568, 1569, 1570, 1571, 1592, 1593, 1597, 1599, 1771,
1028, 1037, 1045, 468, 466, 467, 469, 470, 471, 724, 729, 731, 725, 728, 730, 839, 869, 870, 900,
911, 1231, 1245, 1246, 1247, 1248, 595, 1697, 1699, 1700, 1701, 1702, 1703, 693, 736, 908, 909, 910,
978, 1089, 1094, 1186, 1187, 1229, 1311, 1312, 1313, 1410, 1411, 1412, 1456, 1490, 1494, 1495, 1552,
1553, 1665, 1755, 612, 896, 897, 1036, 1082, 477, 478, 479, 480, 481, 482, 920, 921, 922, 924, 923,
1123, 1124, 1125, 1146, 1773, 684, 685, 686, 687, 871, 872, 891, 892, 893, 894, 913, 1043, 1046,
912, 1050, 1051, 1052, 1053, 1095, 1140, 1164, 1167, 1172, 1181, 1185, 1294, 1350, 1465, 1764, 1483,
614, 797, 1153, 1156, 1157, 1221, 1243, 1244, 1413, 1720, 1749, 1750, 422, 867, 868, 1134, 821, 981,
982, 983, 995, 1020, 1021, 1032, 1379, 1380, 495, 491, 726, 899, 1058, 1059, 1084, 1218, 1255, 1284,
1565, 1736, 487, 485, 522, 314, 489, 490, 484, 601, 630, 631, 632, 633, 634, 635, 636, 637, 476,
475, 683, 939, 940, 942, 1023, 1024, 1025, 1026, 1040, 1083, 1230, 1250, 1288, 1293, 1307, 1373,
1434, 1435, 1436, 1437, 1438, 1439, 1440, 1441, 1547, 1442, 1443, 1444, 1445, 1446, 1447, 1448,
1449, 1450, 1451, 1452, 1498, 1510, 1511, 1512, 1513, 1514, 1515, 1516, 1582, 1583, 1584, 1600,
1606, 1608, 1621, 1629, 1635, 1645, 1662, 1682, 1690, 1726, 1731, 1721, 835, 836, 1378, 1474, 1476,
1477, 1478, 1479, 1500, 1501, 1505, 1506, 1507, 1508, 1533, 1534, 1669, 473, 1369, 1766, 1767, 1768,
1769, 1770, 472, 474, 642, 643, 1251, 1253, 1387, 68, 436, 1673, 1035, 1085, 493) ASC

1