array(4) {
  ["limit"]=>
  int(6)
  ["destinations"]=>
  array(1) {
    [0]=>
    int(32)
  }
  ["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, IF(mh.tip_1_sk
IS NULL or mh.tip_1_sk = '', mh.tip_1, mh.tip_1_sk) as tip_1 , IF(mh.tip_2_sk IS NULL or mh.tip_2_sk
= '', mh.tip_2, mh.tip_2_sk) as tip_2 , IF(mh.tip_3_sk IS NULL or mh.tip_3_sk = '', mh.tip_3,
mh.tip_3_sk) as tip_3 , COALESCE(NULLIF(hr.title,''), h.title) as title,
COALESCE(NULLIF(hr.name,''), h.name) as name, COALESCE(NULLIF(hr.full_name,''), h.full_name) as
full_name, COALESCE(NULLIF(hr.description,''), h.description) as description,
COALESCE(NULLIF(dr.name,''), d.name) as destination_name 
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 JOIN
`mod_hotel_hotel_translation` AS `hr` ON hr.id_parent = h.id JOIN
`mod_destination_destination_translation` AS `dr` ON dr.id_parent = d.id 
WHERE h.parent IN ( 32 ) AND h.state = 1 AND h.not_recommended != 1 AND hr.id_lang = 3 AND
dr.id_lang = 3 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, 68, 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, 436, 989, 1182, 1368, 1563, 627, 1564, 497, 788,
866, 879, 880, 950, 1126, 52, 1242, 1610, 1630, 1640, 1673, 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, 1035, 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, 1085, 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, 493, 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) ASC

1