Site http://www.algarvepropertydatabase.com

Site Crashed WARNING --> 100.24.209.47 ON August 21, 2019, 2:49:15 am

SQL statement that failed below:
---------------------------------------------------------
SELECT listingsdbelements_field_value, count(listingsdbelements_field_value) AS num_type FROM default_en_listingsdbelements, default_en_listingsdb WHERE listingsdbelements_field_name = 'type' AND listingsdb_active = 'yes' AND listingsdbelements_field_value <> '' AND default_en_listingsdbelements.listingsdb_id = default_en_listingsdb.listingsdb_id AND default_en_listingsdb.listingsdb_id IN (22863, 22837, 22835, 34549, 37569, 38857, 37570, 24121, 24128, 34624, 24127, 39497, 22967, 24113, 22924, 22939, 22722, 22999, 22861, 24130, 22721, 23014, 34563, 22826, 22794, 34634, 22959, 24122, 34502, 34617, 22983, 22981, 22982, 22961, 22945, 22781, 22766, 22763, 22762, 22782, 24129, 36346, 24114, 38856, 24124, 26502, 22725, 22719, 30009, 22815, 37559, 34565, 22927, 22767, 34564, 22880, 22870, 22838, 22735, 34566, 22788, 22720, 24118, 22816, 34629, 37566, 24718, 22834, 22958, 22917, 22913, 22823, 41013, 41002, 41015, 41021, 22903, 22888, 22898, 22963, 22784, 22751, 22878, 22944, 22806, 22809, 22808, 22856, 23008, 22807, 22764, 22882, 22918, 22920, 23021, 34547, 34546, 22911, 22980, 22774, 22773, 22923, 22994, 34587, 22951, 22972, 22925, 22941, 34591, 34592, 34557, 34567, 22743, 23005, 23004, 22864, 22904, 22962, 22990, 22803, 22745, 40333, 40004, 40010, 34548, 22821, 22825, 22860, 22889, 22859, 34584, 23011, 22966, 22761, 24111, 34545, 23010, 23013, 22796, 24115, 10996, 22787, 10995, 22919, 24112, 22987, 22975, 22997, 22926, 22970, 10997, 22969, 22855, 37572, 22201, 22965, 22954, 22730, 22732, 22955, 22953, 22946, 22950, 22817, 22818, 22931, 22938, 22988, 23006, 22724, 24126, 34544, 22822, 22989, 22895, 22813, 22812, 22811, 22731, 22801, 38844, 22753, 22752, 22871, 22854, 22780, 22850, 22829, 22789, 22800, 23002, 22948, 22932, 22986, 22819, 22851, 22853, 22849, 22791, 22914, 23144, 22759, 22891, 22977, 34542, 22909, 22979, 22992, 22885, 22949, 22771, 22892, 34540, 22843, 22799, 22943, 22901, 22896, 22957, 22786, 22998, 22894, 22886, 22942, 22867, 22883, 22757, 22775, 22750, 34543, 22728, 34633, 22873, 22937, 22748, 22785, 22742, 22929, 34517, 22727, 22760, 22976, 22884, 22877, 37574, 38861, 34637, 34539, 22993, 22798, 22795, 22797, 22874, 37547, 22814, 22930, 37567, 37568, 38858, 34560, 22936, 22933, 23012, 22865, 22947, 22846, 22852, 22858, 22845, 22749, 22734, 23009, 22956, 22928, 22902, 22952, 23007, 22810, 22805, 22940, 23003, 22792, 22868, 22879, 22881, 22960, 22984, 22830, 22747, 22876, 22875, 22831, 22985, 22824, 22744, 22790, 22991, 22916, 22996, 22905, 22848, 25675, 37764, 22840, 22847, 22968, 22778, 22907, 39659, 39663, 22758, 37575, 36620, 22197, 31820, 36619, 31827, 36624, 22729, 23000, 22887, 22964, 22973, 22974, 22922, 22921, 23015, 22971, 22740, 22769, 22772, 22726, 22776, 36698, 36786, 39065, 34628, 34605, 16631, 34612, 22995, 22862, 25219, 22754, 34558, 34536, 24110, 23001, 34615, 35427, 37561, 11000, 34537, 22783, 22890, 22839, 22912, 22833, 11001, 34535, 22915, 22857, 22866, 22872, 22802, 34530, 40332, 22978, 22869, 22755, 22741, 40330, 40645, 25223, 22900, 36688, 34598, 34614, 22934, 22793, 22756, 40486, 34534, 39477, 22836, 39433, 24109, 34636, 34533, 26501, 36734, 34532, 34531, 37554, 34569, 22899, 36701, 31823, 24116, 38847, 22910, 22908, 34608, 36660, 41029, 38855, 24119, 40336, 36637, 22804, 24131, 22723, 24117, 37579, 38865, 38864, 36741, 34600, 34504, 34509, 22842, 36459, 22208, 36631, 36625, 34527, 34529, 22736, 22738, 22737, 24107, 40168, 22935, 40313, 39658, 34521, 34499, 36739, 37578, 36735, 34626, 22893, 34597, 36653, 36738, 36732, 36733, 40063, 40084, 34583, 22841, 22739, 34621, 22777, 34606, 24108, 37734, 22820, 40510, 22906, 22897, 22828, 34627, 34652, 38853, 40136, 39668, 31826, 36737, 34057, 12297, 40696, 40998, 34594, 34550, 34522, 34541, 34631, 38911, 36357, 34609, 34611, 39677, 39678, 34619, 40741, 34579, 34589, 34523, 34524, 34574, 34575, 34576, 36743, 40167, 40797, 40576, 40575, 40573, 34525, 34620, 34593, 37557, 38987, 39003, 40554, 39009, 34074, 34520, 34590, 36449, 39535, 41007, 39478, 22695, 34581, 34577, 34578, 39094, 37576, 41025, 40549, 34603, 37553, 37555, 40435, 39069, 40809, 40170, 39479, 41018, 39475, 39473, 39621, 41017, 36635, 34519, 31639, 40819, 40896, 39315, 40349, 36721, 38859, 41026, 41027, 14681, 39729, 34570, 39736, 39737, 36742, 36731, 38973, 39234, 41024, 36628, 39286, 39373, 36728, 38896, 40810, 22607, 40971, 38848, 38992, 22608, 36685, 36745, 36617, 38849, 38850, 38851, 39282, 34516, 38787, 22616, 34585, 40199, 40470, 36610, 40234, 36636, 34613, 34073, 36612, 39273, 41008, 41009, 29030, 41022, 41014, 40982, 38118, 41001, 41000, 41003, 41004, 34505, 34515, 34514, 34513, 38829, 35483, 39650, 40260, 22844, 39267, 41028, 24125, 39262, 34562, 36720, 40964, 34055, 40134, 22746, 34607, 34588, 36705, 40828, 40826, 40827, 40772, 40774, 22675, 39072, 34610, 34512, 34616, 22832, 22827, 40427, 39251, 39555, 34635, 34501, 40129, 41011, 40910, 40869, 40870, 40871, 40872, 40899, 40989, 41020, 40900, 40904, 40903, 40940, 40943, 39055, 39249, 39474, 34572, 34573, 39997, 39994, 40179, 40511, 34479, 40334, 40018, 40019, 40020, 40024, 40025, 34551, 34552, 34555, 34556, 19047, 41016, 40990, 40993, 36695, 39346, 38963, 34355, 36740, 34595, 22770, 22765, 36719, 34604, 34571, 40062, 22779, 22733, 34511, 22768, 39553, 40949, 39310, 40999, 40986, 38893, 40992, 40178, 39021, 39654, 40988, 40994, 40972, 41019, 39232, 40833, 40642, 39157, 39711, 40472, 40474, 34503, 39351, 40887, 40886, 38913, 39077, 39340, 40984, 39076, 39214, 34518, 34510, 32381, 34526, 36646, 38912, 34506, 34507, 34508, 38944, 38958, 38952, 39210, 39432, 39394, 38792, 34596, 40479, 40381, 34559, 38836, 34553, 34554, 40845, 39018, 39043, 38959, 40249, 38195, 34410, 40344, 40477, 38190, 40471, 39419, 40448, 24719, 38977, 37562, 39019, 40468, 37558, 34354, 37714, 36615, 37738, 40942, 40946, 40727, 40760, 40263, 40391, 40868, 40255, 40200, 40394, 38427, 40661, 40291, 40588, 40589, 40551, 40947, 40733, 40409, 40481, 40478, 40482, 40212, 40223, 40177, 39557, 40475, 40484, 40412, 40397, 40753, 40754, 33841, 40290, 40193, 39414, 40064, 40066, 31816, 36598, 38909, 38327, 36694, 40265, 36644, 40267, 40393, 40059, 40365, 39674, 24106, 40672, 16433, 31810, 37546, 38846, 40566, 24120, 39177, 40913, 40379, 38935, 34500, 24177, 24178, 24123, 24132, 24133, 24134, 24135, 24136, 24137, 24138, 24139, 38360, 40785, 39181, 24173, 24174, 24176, 24175, 40652, 24171, 34496, 34474, 40766, 24170, 24168, 24163, 24164, 24162, 24165, 24166, 24149, 24145, 24151, 24152, 24153, 24161, 24159, 24160, 24157, 24158, 24154, 24155, 24148, 24147, 24140, 24141, 24143, 24144, 24146, 24169, 24172, 24142, 34497, 29843, 34586, 40748, 34618, 34495, 34625, 39343, 39339, 30181, 30011, 34622, 36696, 34582, 34538, 25739, 34494, 34493, 34492, 38331, 38985, 34490, 34489, 34491, 37733, 34488, 38941, 40548, 39152, 40997, 22210, 34487, 34486, 31824, 40002, 40570, 31818, 40402, 40230, 40238, 40148, 34485, 39693, 34484, 39520, 40299, 40829, 40771, 40098, 39615, 37552, 22206, 37556, 41010, 39604, 22209, 36722, 22199, 34483, 34482, 40879, 36626, 38898, 38845, 22203, 36689, 36725, 40682, 40492, 36693, 28912, 25207, 38927, 40782, 40938, 39703, 40919, 40721, 40891, 39059, 40824, 38892, 38886, 22614, 22613, 38883, 40784, 38783, 40755, 31830, 34580, 34481, 36633, 34480, 40205, 39545, 34568, 34640, 40758, 34478, 40214, 34426, 39174, 39665, 34477, 40663, 40392, 40480, 34651, 40787, 40801, 31813, 23146, 36605, 39672, 36692, 23148, 37551, 23186, 23150, 23151, 23152, 23153, 23154, 23155, 23156, 23157, 23158, 23159, 23160, 23161, 23162, 23163, 23164, 23165, 23166, 23167, 23168, 23169, 23170, 23171, 23172, 23173, 23174, 23175, 23176, 23177, 23178, 23179, 23180, 23181, 23182, 23183, 23184, 23185, 23187, 23188, 23189, 23190, 23191, 23192, 23194, 23195, 23196, 23197, 23198, 23199, 23200, 23201, 23202, 23203, 23204, 23205, 23206, 23207, 23208, 23209, 23210, 23211, 23212, 23213, 23214, 23215, 23216, 23217, 23218, 23219, 23220, 23221, 23222, 23223, 23224, 23225, 23226, 23227, 23228, 23229, 23230, 23231, 23232, 23233, 23234, 23235, 23236, 23237, 23238, 23239, 23240, 23241, 23242, 23243, 23244, 23245, 23246, 23247, 23248, 23249, 23250, 23251, 23252, 23253, 23254, 23255, 23256, 23257, 23258, 23259, 23260, 23261, 23262, 23263, 23264, 23265, 23266, 23268, 23269, 39622, 39614, 36307, 40054, 34336, 38176, 36643, 40465, 40049, 40051, 40337, 40338, 40042, 40043, 40048, 40087, 40340, 29999, 40085, 40041, 39495, 40036, 40038, 40078, 40079, 40080, 40009, 40017, 40014, 40075, 40074, 40032, 40028, 39652, 40073, 40035, 40072, 39358, 40056, 40070, 40339, 40068, 40034, 39985, 39986, 39987, 39988, 40067, 39983, 40003, 40445, 40053, 40047, 40081, 34471, 39429, 40099, 31631, 40005, 40029, 40335, 40030, 40289, 38418, 40061, 34476, 39345, 41023, 34632, 35679, 40217, 38160, 40300, 40403, 40671, 40251, 38297, 40670, 40669, 38320, 38210, 39662, 40469, 38252, 38274, 39700, 40218, 38333, 38334, 40111, 38131, 38216, 39406, 40668, 35678, 31831, 40398, 40667, 34561, 39415, 38243, 34472, 34473, 34498, 39989, 39990, 39976, 35450, 40653, 40216, 40666, 35449, 38249, 40658, 40196, 39713, 39139, 36602, 38161, 40665, 38202, 30048, 30045, 40664, 32377, 31778, 30023, 30028, 30029, 30035, 40312, 34470, 30019, 34475, 38786, 40973, 40552, 40530, 29975, 35440, 38257, 40375, 29989, 32378, 40662, 40660, 39056, 39049, 40958, 36611, 38854, 23147, 40358, 40357, 39007, 39105, 40778, 41005, 40975, 40948, 41012, 40865, 40844, 36708, 34623, 34630, 31828, 40634, 34528, 40272, 36691, 38964, 34599, 34601, 34602, 39115, 37716, 39095, 39091, 40659, 38271, 38140, 40675, 38292, 38201, 38137, 40462, 40917, 40861, 40864, 40437, 39085, 35485, 40191, 40464, 40463, 38961, 40709, 38910, 40515, 40460, 39375, 38820, 40561, 40046, 36460, 38363, 36594, 22188, 39341, 40655, 38914, 40657, 38822, 40656, 40543, 40767, 39653, 40841, 40654, 40128, 29037, 39637, 40707, 40016, 40519, 40450, 39984, 39978, 39977, 39975, 40331, 0, 40714, 40560, 39017, 39022, 39323, 39024, 39025, 39026, 39071, 39030, 37544, 38748, 40001, 40651, 40650, 38891, 40587, 39634, 38882, 39044, 37577, 38862, 38863, 38971, 37571, 38981, 38842, 38843, 38840, 37408, 22610, 38852, 36638, 38956, 36647, 36649, 36655, 36658, 36686, 36715, 38860, 36714, 36727, 36713, 36709, 36702, 36703, 36707, 36699, 36706, 36704, 36726, 39190, 39968, 39970, 38887, 38888, 38889, 40592, 38895, 38897, 38899, 40594, 38905, 39368, 38907, 40553, 38915, 40597, 38920, 40599, 38921, 38925, 40600, 38930, 38931, 38932, 40602, 39603, 38942, 38943, 40849, 38948, 38949, 38950, 38954, 38955, 38957, 38962, 38983, 39052, 38975, 38976, 38978, 38969, 38972, 40533, 39032, 39344, 39042, 39045, 39046, 39047, 39051, 39057, 39062, 39066, 39717, 39067, 39079, 39081, 40558, 39097, 39098, 40310, 39106, 39107, 39109, 39110, 39559, 39113, 39116, 39121, 39126, 39127, 39135, 39178, 39144, 39714, 40565, 39331, 39169, 39170, 39171, 39180, 40569, 39187, 39188, 39195, 40571, 40311, 39201, 39202, 39219, 39266, 39224, 39221, 39204, 39227, 39261, 39238, 39213, 39235, 39504, 39225, 40192, 39568, 40574, 39268, 39272, 39274, 39277, 39606, 39278, 39352, 39289, 39290, 39291, 39294, 39295, 39296, 40823, 40624, 40626) AND default_en_listingsdb.userdb_id= GROUP BY default_en_listingsdbelements.listingsdbelements_field_value ORDER BY listingsdbelements_field_value