| |
Could not query hr_url
DEBUG MODE
SQL Error : 1 Can't create/write to file '/tmp/#sql_27b8_0.MYI' (Errcode: 122)
SELECT *, url_id as urlid, (url_rec_cnt / 43 * 10) + user_session_time / 1227086801 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1>1500 and user_zip in (501, 544, 1001, 1008, 1028, 1029, 1030, 1034, 1036, 1071, 1077, 1085, 1086, 1089, 1097, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1115, 1118, 1119, 1128, 1129, 1144, 1199, 1222, 1231, 1244, 1245, 1255, 1257, 1258, 1259, 1634, 2789, 2804, 2807, 2808, 2812, 2813, 2817, 2822, 2827, 2832, 2833, 2836, 2854, 2873, 2874, 2875, 2877, 2879, 2880, 2881, 2882, 2883, 2891, 2892, 2894, 2898, 6001, 6002, 6006, 6010, 6011, 6013, 6016, 6018, 6019, 6020, 6021, 6022, 6023, 6024, 6025, 6026, 6027, 6028, 6029, 6030, 6031, 6032, 6033, 6034, 6035, 6037, 6039, 6040, 6041, 6043, 6045, 6049, 6050, 6051, 6052, 6053, 6057, 6058, 6059, 6060, 6061, 6062, 6063, 6064, 6065, 6066, 6067, 6068, 6069, 6070, 6071, 6072, 6073, 6074, 6075, 6076, 6077, 6078, 6079, 6080, 6081, 6082, 6083, 6084, 6085, 6087, 6088, 6089, 6090, 6091, 6092, 6093, 6094, 6095, 6096, 6098, 6101, 6102, 6103, 6104, 6105, 6106, 6107, 6108, 6109, 6110, 6111, 6112, 6114, 6115, 6117, 6118, 6119, 6120, 6123, 6126, 6127, 6128, 6129, 6131, 6132, 6133, 6134, 6137, 6138, 6140, 6141, 6142, 6143, 6144, 6145, 6146, 6147, 6150, 6151, 6152, 6153, 6154, 6155, 6156, 6160, 6161, 6167, 6176, 6180, 6183, 6199, 6226, 6230, 6231, 6232, 6233, 6234, 6235, 6237, 6238, 6239, 6241, 6242, 6243, 6247, 6248, 6249, 6250, 6251, 6254, 6256, 6258, 6259, 6263, 6264, 6265, 6266, 6268, 6269, 6278, 6279, 6280, 6282, 6320, 6330, 6331, 6332, 6333, 6334, 6335, 6336, 6337, 6339, 6340, 6349, 6350, 6351, 6353, 6354, 6355, 6357, 6359, 6360, 6365, 6370, 6371, 6372, 6373, 6374, 6375, 6376, 6377, 6378, 6379, 6380, 6382, 6383, 6384, 6385, 6386, 6387, 6388, 6389, 6390, 6401, 6403, 6404, 6405, 6408, 6409, 6410, 6411, 6412, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6422, 6423, 6424, 6426, 6430, 6431, 6432, 6436, 6437, 6438, 6439, 6440, 6441, 6442, 6443, 6444, 6447, 6450, 6451, 6454, 6455, 6456, 6457, 6459, 6460, 6467, 6468, 6469, 6470, 6471, 6472, 6473, 6474, 6475, 6477, 6478, 6479, 6480, 6481, 6482, 6483, 6484, 6487, 6488, 6489, 6490, 6491, 6492, 6493, 6494, 6497, 6498, 6501, 6502, 6503, 6504, 6505, 6506, 6507, 6508, 6509, 6510, 6511, 6512, 6513, 6514, 6515, 6516, 6517, 6518, 6519, 6520, 6521, 6524, 6525, 6530, 6531, 6532, 6533, 6534, 6535, 6536, 6537, 6538, 6540, 6601, 6602, 6604, 6605, 6606, 6607, 6608, 6610, 6611, 6612, 6614, 6615, 6650, 6673, 6699, 6701, 6702, 6703, 6704, 6705, 6706, 6708, 6710, 6712, 6716, 6720, 6721, 6722, 6723, 6724, 6725, 6726, 6731, 6748, 6749, 6750, 6751, 6752, 6753, 6754, 6755, 6756, 6757, 6758, 6759, 6762, 6763, 6770, 6776, 6777, 6778, 6779, 6781, 6782, 6783, 6784, 6785, 6786, 6787, 6790, 6791, 6793, 6794, 6795, 6796, 6798, 6801, 6804, 6807, 6810, 6811, 6812, 6813, 6814, 6815, 6816, 6817, 6819, 6820, 6824, 6825, 6829, 6830, 6831, 6832, 6836, 6840, 6842, 6850, 6851, 6852, 6853, 6854, 6855, 6856, 6857, 6858, 6859, 6860, 6870, 6875, 6876, 6877, 6878, 6879, 6880, 6881, 6883, 6888, 6889, 6890, 6896, 6897, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6910, 6911, 6912, 6913, 6914, 6920, 6921, 6922, 6925, 6926, 6927, 6928, 6993, 7001, 7002, 7003, 7004, 7005, 7006, 7007, 7008, 7009, 7010, 7011, 7012, 7013, 7014, 7015, 7016, 7017, 7018, 7019, 7020, 7021, 7022, 7023, 7024, 7026, 7027, 7028, 7029, 7030, 7031, 7032, 7033, 7034, 7035, 7036, 7039, 7040, 7041, 7042, 7043, 7044, 7045, 7046, 7047, 7050, 7051, 7052, 7054, 7055, 7057, 7058, 7059, 7060, 7061, 7062, 7063, 7064, 7065, 7066, 7067, 7068, 7069, 7070, 7071, 7072, 7073, 7074, 7075, 7076, 7077, 7078, 7079, 7080, 7081, 7082, 7083, 7086, 7087, 7088, 7090, 7091, 7092, 7093, 7094, 7095, 7096, 7097, 7099, 7101, 7102, 7103, 7104, 7105, 7106, 7107, 7108, 7109, 7110, 7111, 7112, 7114, 7115, 7175, 7182, 7184, 7188, 7189, 7191, 7192, 7193, 7194, 7195, 7197, 7198, 7199, 7201, 7202, 7203, 7204, 7205, 7206, 7207, 7208, 7290, 7301, 7302, 7303, 7304, 7305, 7306, 7307, 7308, 7309, 7310, 7311, 7399, 7401, 7403, 7405, 7407, 7410, 7416, 7417, 7418, 7419, 7420, 7421, 7422, 7423, 7424, 7427, 7428, 7430, 7432, 7435, 7436, 7438, 7439, 7440, 7442, 7444, 7446, 7450, 7451, 7452, 7456, 7457, 7458, 7460, 7461, 7462, 7463, 7465, 7470, 7474, 7477, 7480, 7481, 7495, 7498, 7501, 7502, 7503, 7504, 7505, 7506, 7507, 7508, 7509, 7510, 7511, 7512, 7513, 7514, 7522, 7524, 7530, 7533, 7538, 7543, 7544, 7571, 7601, 7602, 7603, 7604, 7605, 7606, 7607, 7608, 7610, 7620, 7621, 7624, 7626, 7627, 7628, 7630, 7631, 7632, 7640, 7641, 7642, 7643, 7644, 7645, 7646, 7647, 7648, 7649, 7650, 7652, 7653, 7656, 7657, 7660, 7661, 7662, 7663, 7666, 7670, 7675, 7676, 7677, 7688, 7701, 7702, 7703, 7704, 7709, 7710, 7711, 7712, 7715, 7716, 7717, 7718, 7719, 7720, 7721, 7722, 7723, 7724, 7726, 7727, 7728, 7730, 7731, 7732, 7733, 7734, 7735, 7737, 7738, 7739, 7740, 7746, 7747, 7748, 7750, 7751, 7752, 7753, 7754, 7755, 7756, 7757, 7758, 7760, 7762, 7763, 7764, 7765, 7777, 7799, 7801, 7802, 7803, 7806, 7819, 7820, 7821, 7822, 7826, 7827, 7828, 7830, 7831, 7834, 7836, 7837, 7838, 7839, 7840, 7841, 7842, 7843, 7845, 7846, 7847, 7848, 7849, 7850, 7852, 7853, 7855, 7856, 7857, 7860, 7865, 7866, 7869, 7870, 7871, 7874, 7875, 7876, 7877, 7878, 7879, 7880, 7885, 7890, 7901, 7902, 7919, 7920, 7921, 7922, 7924, 7926, 7927, 7928, 7930, 7931, 7932, 7933, 7934, 7935, 7936, 7938, 7939, 7940, 7945, 7946, 7950, 7952, 7960, 7961, 7962, 7963, 7969, 7970, 7974, 7976, 7977, 7978, 7979, 7980, 7981, 7983, 7997, 7999, 8005, 8006, 8008, 8015, 8022, 8041, 8042, 8050, 8064, 8092, 8501, 8502, 8504, 8505, 8510, 8511, 8512, 8514, 8515, 8520, 8525, 8526, 8527, 8528, 8533, 8534, 8535, 8536, 8540, 8541, 8542, 8543, 8544, 8550, 8551, 8553, 8555, 8557, 8558, 8560, 8561, 8562, 8570, 8601, 8602, 8603, 8604, 8605, 8606, 8607, 8608, 8609, 8610, 8611, 8618, 8619, 8620, 8625, 8628, 8629, 8638, 8640, 8641, 8645, 8646, 8647, 8648, 8650, 8666, 8677, 8690, 8691, 8695, 8701, 8720, 8721, 8722, 8723, 8724, 8730, 8731, 8732, 8733, 8734, 8735, 8736, 8738, 8739, 8740, 8741, 8742, 8750, 8751, 8752, 8753, 8754, 8755, 8756, 8757, 8758, 8759, 8792, 8801, 8803, 8805, 8807, 8809, 8810, 8812, 8816, 8817, 8818, 8820, 8821, 8822, 8823, 8824, 8826, 8828, 8829, 8830, 8831, 8832, 8833, 8834, 8835, 8836, 8837, 8840, 8844, 8846, 8850, 8851, 8852, 8853, 8854, 8855, 8857, 8858, 8859, 8861, 8862, 8863, 8868, 8869, 8870, 8871, 8872, 8873, 8875, 8876, 8877, 8878, 8879, 8880, 8882, 8884, 8885, 8887, 8888, 8889, 8890, 8896, 8899, 8901, 8902, 8903, 8904, 8905, 8906, 8907, 8922, 8933, 8988, 8989, 10001, 10002, 10003, 10004, 10005, 10006, 10007, 10008, 10009, 10010, 10011, 10012, 10013, 10014, 10015, 10016, 10017, 10018, 10019, 10020, 10021, 10022, 10023, 10024, 10025, 10026, 10027, 10028, 10029, 10030, 10031, 10032, 10033, 10034, 10035, 10036, 10037, 10038, 10039, 10040, 10041, 10043, 10044, 10045, 10046, 10047, 10048, 10055, 10060, 10069, 10072, 10079, 10080, 10081, 10082, 10087, 10090, 10094, 10095, 10096, 10098, 10099, 10101, 10102, 10103, 10104, 10105, 10106, 10107, 10108, 10109, 10110, 10111, 10112, 10113, 10114, 10115, 10116, 10117, 10118, 10119, 10120, 10121, 10122, 10123, 10124, 10125, 10126, 10128, 10129, 10130, 10131, 10132, 10133, 10138, 10149, 10150, 10151, 10152, 10153, 10154, 10155, 10156, 10157, 10158, 10159, 10160, 10161, 10162, 10163, 10164, 10165, 10166, 10167, 10168, 10169, 10170, 10171, 10172, 10173, 10174, 10175, 10176, 10177, 10178, 10179, 10184, 10185, 10196, 10197, 10199, 10203, 10211, 10212, 10213, 10242, 10249, 10250, 10256, 10257, 10258, 10259, 10260, 10261, 10265, 10268, 10269, 10270, 10271, 10272, 10273, 10274, 10275, 10276, 10277, 10278, 10279, 10280, 10281, 10282, 10285, 10286, 10292, 10301, 10302, 10303, 10304, 10305, 10306, 10307, 10308, 10309, 10310, 10311, 10312, 10313, 10314, 10422, 10451, 10452, 10453, 10454, 10455, 10456, 10457, 10458, 10459, 10460, 10461, 10462, 10463, 10464, 10465, 10466, 10467, 10468, 10469, 10470, 10471, 10472, 10473, 10474, 10475, 10499, 10501, 10502, 10503, 10504, 10505, 10506, 10507, 10509, 10510, 10511, 10512, 10514, 10516, 10517, 10518, 10519, 10520, 10521, 10522, 10523, 10524, 10526, 10527, 10528, 10530, 10532, 10533, 10535, 10536, 10537, 10538, 10540, 10541, 10542, 10543, 10545, 10546, 10547, 10548, 10549, 10550, 10551, 10552, 10553, 10557, 10558, 10559, 10560, 10562, 10566, 10567, 10570, 10571, 10572, 10573, 10576, 10577, 10578, 10579, 10580, 10581, 10583, 10586, 10587, 10588, 10589, 10590, 10591, 10592, 10594, 10595, 10596, 10597, 10598, 10601, 10602, 10603, 10604, 10605, 10606, 10607, 10610, 10625, 10629, 10633, 10650, 10701, 10702, 10703, 10704, 10705, 10706, 10707, 10708, 10709, 10710, 10730, 10801, 10802, 10803, 10804, 10805, 10901, 10910, 10911, 10912, 10913, 10914, 10915, 10916, 10917, 10918, 10919, 10920, 10921, 10922, 10923, 10924, 10925, 10926, 10927, 10928, 10930, 10931, 10932, 10933, 10940, 10941, 10943, 10946, 10950, 10952, 10953, 10954, 10956, 10957, 10958, 10959, 10960, 10962, 10963, 10964, 10965, 10968, 10969, 10970, 10973, 10974, 10975, 10976, 10977, 10979, 10980, 10981, 10982, 10983, 10984, 10985, 10986, 10987, 10988, 10989, 10990, 10992, 10993, 10994, 10995, 10996, 10997, 10998, 11001, 11002, 11003, 11004, 11005, 11010, 11020, 11021, 11022, 11023, 11024, 11025, 11026, 11027, 11030, 11040, 11041, 11042, 11043, 11044, 11050, 11051, 11052, 11053, 11054, 11055, 11096, 11099, 11101, 11102, 11103, 11104, 11105, 11106, 11109, 11120, 11201, 11202, 11203, 11204, 11205, 11206, 11207, 11208, 11209, 11210, 11211, 11212, 11213, 11214, 11215, 11216, 11217, 11218, 11219, 11220, 11221, 11222, 11223, 11224, 11225, 11226, 11228, 11229, 11230, 11231, 11232, 11233, 11234, 11235, 11236, 11237, 11238, 11239, 11240, 11241, 11242, 11243, 11244, 11245, 11247, 11248, 11249, 11251, 11252, 11254, 11255, 11256, 11286, 11302, 11351, 11352, 11353, 11354, 11355, 11356, 11357, 11358, 11359, 11360, 11361, 11362, 11363, 11364, 11365, 11366, 11367, 11368, 11369, 11370, 11371, 11372, 11373, 11374, 11375, 11377, 11378, 11379, 11380, 11381, 11385, 11386, 11388, 11390, 11405, 11411, 11412, 11413, 11414, 11415, 11416, 11417, 11418, 11419, 11420, 11421, 11422, 11423, 11424, 11425, 11426, 11427, 11428, 11429, 11430, 11431, 11432, 11433, 11434, 11435, 11436, 11439, 11451, 11484, 11499, 11501, 11507, 11509, 11510, 11514, 11516, 11517, 11518, 11520, 11530, 11531, 11535, 11536, 11542, 11545, 11547, 11548, 11549, 11550, 11551, 11552, 11553, 11554, 11555, 11556, 11557, 11558, 11559, 11560, 11561, 11562, 11563, 11564, 11565, 11566, 11568, 11569, 11570, 11571, 11572, 11575, 11576, 11577, 11579, 11580, 11581, 11582, 11583, 11588, 11590, 11592, 11593, 11594, 11595, 11596, 11597, 11598, 11599, 11690, 11691, 11692, 11693, 11694, 11695, 11696, 11697, 11701, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11713, 11714, 11715, 11716, 11717, 11718, 11719, 11720, 11721, 11722, 11724, 11725, 11726, 11727, 11729, 11730, 11731, 11732, 11733, 11735, 11736, 11737, 11738, 11739, 11740, 11741, 11742, 11743, 11745, 11746, 11747, 11749, 11750, 11751, 11752, 11753, 11754, 11755, 11756, 11757, 11758, 11760, 11762, 11763, 11764, 11765, 11766, 11767, 11768, 11769, 11770, 11771, 11772, 11773, 11774, 11775, 11776, 11777, 11778, 11779, 11780, 11782, 11783, 11784, 11786, 11787, 11788, 11789, 11790, 11791, 11792, 11793, 11794, 11795, 11796, 11797, 11798, 11801, 11802, 11803, 11804, 11805, 11815, 11819, 11853, 11854, 11855, 11901, 11930, 11931, 11932, 11933, 11934, 11935, 11937, 11939, 11940, 11941, 11942, 11944, 11946, 11947, 11948, 11949, 11950, 11951, 11952, 11953, 11954, 11955, 11956, 11957, 11958, 11959, 11960, 11961, 11962, 11963, 11964, 11965, 11967, 11968, 11969, 11970, 11971, 11972, 11973, 11975, 11976, 11977, 11978, 11980, 12401, 12404, 12411, 12417, 12419, 12420, 12428, 12429, 12432, 12440, 12443, 12446, 12449, 12466, 12471, 12472, 12483, 12484, 12486, 12487, 12489, 12493, 12501, 12502, 12503, 12504, 12506, 12507, 12508, 12509, 12510, 12511, 12512, 12514, 12515, 12516, 12517, 12518, 12520, 12522, 12523, 12524, 12525, 12527, 12528, 12531, 12533, 12537, 12538, 12540, 12542, 12543, 12545, 12546, 12547, 12548, 12549, 12550, 12551, 12552, 12553, 12555, 12557, 12561, 12563, 12564, 12566, 12567, 12568, 12569, 12570, 12571, 12572, 12574, 12575, 12577, 12578, 12580, 12581, 12582, 12584, 12585, 12586, 12589, 12590, 12592, 12594, 12601, 12602, 12603, 12604, 12721, 12729, 12739, 12746, 12769, 12771, 12780, 12785, 12790, 12938, 18336, 18340, 19067)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
