| |
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 / 48 * 10) + user_session_time / 1227028887 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1140 and user_zip in (7001, 7002, 7003, 7004, 7005, 7006, 7007, 7008, 7009, 7010, 7011, 7012, 7013, 7014, 7015, 7016, 7017, 7018, 7019, 7021, 7022, 7023, 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, 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, 7606, 7607, 7608, 7643, 7644, 7650, 7652, 7653, 7657, 7660, 7661, 7662, 7663, 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, 7823, 7825, 7826, 7827, 7828, 7829, 7830, 7831, 7832, 7833, 7834, 7836, 7837, 7838, 7839, 7840, 7841, 7842, 7843, 7844, 7845, 7846, 7847, 7848, 7849, 7850, 7851, 7852, 7853, 7855, 7856, 7857, 7860, 7863, 7865, 7866, 7869, 7870, 7871, 7874, 7875, 7876, 7877, 7878, 7879, 7880, 7881, 7882, 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, 8001, 8002, 8003, 8004, 8005, 8006, 8007, 8008, 8009, 8010, 8011, 8012, 8014, 8015, 8016, 8017, 8018, 8019, 8020, 8021, 8022, 8023, 8025, 8026, 8027, 8028, 8029, 8030, 8031, 8032, 8033, 8034, 8035, 8036, 8037, 8038, 8039, 8041, 8042, 8043, 8045, 8046, 8048, 8049, 8050, 8051, 8052, 8053, 8054, 8055, 8056, 8057, 8059, 8060, 8061, 8062, 8063, 8064, 8065, 8066, 8067, 8068, 8069, 8070, 8071, 8072, 8073, 8074, 8075, 8076, 8077, 8078, 8079, 8080, 8081, 8083, 8084, 8085, 8086, 8087, 8088, 8089, 8090, 8091, 8092, 8093, 8094, 8095, 8096, 8097, 8098, 8099, 8101, 8102, 8103, 8104, 8105, 8106, 8107, 8108, 8109, 8110, 8201, 8203, 8205, 8210, 8213, 8215, 8217, 8220, 8221, 8223, 8224, 8225, 8226, 8227, 8230, 8231, 8232, 8234, 8237, 8240, 8241, 8243, 8244, 8245, 8248, 8251, 8253, 8270, 8283, 8302, 8310, 8311, 8312, 8313, 8314, 8315, 8316, 8317, 8318, 8319, 8320, 8321, 8322, 8323, 8324, 8326, 8327, 8328, 8329, 8330, 8332, 8334, 8340, 8341, 8342, 8343, 8344, 8345, 8346, 8347, 8348, 8349, 8350, 8352, 8353, 8360, 8361, 8362, 8370, 8401, 8402, 8403, 8404, 8405, 8406, 8501, 8502, 8504, 8505, 8510, 8511, 8512, 8514, 8515, 8518, 8520, 8525, 8526, 8527, 8528, 8530, 8533, 8534, 8535, 8536, 8540, 8541, 8542, 8543, 8544, 8550, 8551, 8553, 8554, 8555, 8556, 8557, 8558, 8559, 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, 8802, 8803, 8804, 8805, 8807, 8808, 8809, 8810, 8812, 8816, 8817, 8818, 8820, 8821, 8822, 8823, 8824, 8825, 8826, 8827, 8828, 8829, 8830, 8831, 8832, 8833, 8834, 8835, 8836, 8837, 8840, 8844, 8846, 8848, 8850, 8851, 8852, 8853, 8854, 8855, 8857, 8858, 8859, 8861, 8862, 8863, 8865, 8867, 8868, 8869, 8870, 8871, 8872, 8873, 8875, 8876, 8877, 8878, 8879, 8880, 8882, 8884, 8885, 8886, 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, 10036, 10038, 10041, 10043, 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, 10116, 10117, 10118, 10119, 10120, 10121, 10122, 10123, 10124, 10125, 10126, 10129, 10130, 10131, 10132, 10133, 10138, 10149, 10150, 10151, 10152, 10153, 10154, 10155, 10156, 10157, 10158, 10159, 10160, 10161, 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, 10925, 10933, 10969, 10979, 10988, 10990, 10998, 11201, 11202, 11203, 11204, 11205, 11206, 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, 11238, 11240, 11241, 11242, 11243, 11244, 11245, 11247, 11248, 11249, 11251, 11252, 11254, 11255, 11256, 11286, 11517, 11697, 12719, 12732, 12737, 12739, 12743, 12746, 12764, 12770, 12771, 12780, 12792, 16820, 16832, 16854, 16872, 16882, 17001, 17003, 17005, 17006, 17007, 17008, 17009, 17010, 17011, 17012, 17013, 17014, 17015, 17016, 17017, 17018, 17019, 17020, 17021, 17022, 17023, 17024, 17025, 17026, 17027, 17028, 17029, 17030, 17031, 17032, 17033, 17034, 17035, 17036, 17037, 17038, 17039, 17040, 17041, 17042, 17043, 17044, 17045, 17046, 17047, 17048, 17049, 17050, 17053, 17055, 17056, 17057, 17058, 17059, 17061, 17062, 17063, 17064, 17065, 17067, 17068, 17069, 17070, 17071, 17072, 17073, 17074, 17076, 17077, 17078, 17080, 17081, 17082, 17083, 17085, 17086, 17087, 17088, 17089, 17090, 17091, 17093, 17094, 17097, 17098, 17099, 17101, 17102, 17103, 17104, 17105, 17106, 17107, 17108, 17109, 17110, 17111, 17112, 17113, 17120, 17121, 17122, 17123, 17124, 17125, 17126, 17127, 17128, 17129, 17130, 17140, 17177, 17214, 17222, 17240, 17241, 17254, 17257, 17261, 17266, 17275, 17301, 17302, 17303, 17304, 17306, 17307, 17309, 17310, 17311, 17312, 17313, 17314, 17315, 17316, 17317, 17318, 17319, 17320, 17321, 17322, 17323, 17324, 17325, 17326, 17327, 17329, 17331, 17332, 17333, 17337, 17339, 17340, 17342, 17343, 17344, 17345, 17346, 17347, 17349, 17350, 17352, 17353, 17354, 17355, 17356, 17358, 17360, 17361, 17362, 17363, 17364, 17365, 17366, 17368, 17370, 17371, 17372, 17375, 17401, 17402, 17403, 17404, 17405, 17406, 17407, 17415, 17501, 17502, 17503, 17504, 17505, 17506, 17507, 17508, 17509, 17511, 17512, 17516, 17517, 17518, 17519, 17520, 17521, 17522, 17527, 17528, 17529, 17532, 17533, 17534, 17535, 17536, 17537, 17538, 17540, 17543, 17545, 17547, 17549, 17550, 17551, 17552, 17554, 17555, 17557, 17560, 17562, 17563, 17564, 17565, 17566, 17567, 17568, 17569, 17570, 17572, 17573, 17575, 17576, 17577, 17578, 17579, 17580, 17581, 17582, 17583, 17584, 17585, 17601, 17602, 17603, 17604, 17605, 17606, 17607, 17608, 17699, 17701, 17702, 17703, 17705, 17720, 17722, 17723, 17727, 17728, 17730, 17731, 17737, 17742, 17744, 17747, 17749, 17752, 17754, 17756, 17757, 17758, 17759, 17762, 17768, 17769, 17772, 17774, 17777, 17786, 17801, 17810, 17812, 17813, 17814, 17815, 17820, 17821, 17822, 17823, 17824, 17825, 17827, 17828, 17829, 17830, 17831, 17832, 17833, 17834, 17835, 17836, 17837, 17839, 17840, 17841, 17842, 17843, 17844, 17845, 17846, 17847, 17850, 17851, 17853, 17855, 17856, 17857, 17858, 17859, 17860, 17861, 17862, 17864, 17865, 17866, 17867, 17868, 17870, 17872, 17876, 17877, 17878, 17880, 17881, 17882, 17883, 17884, 17885, 17886, 17887, 17888, 17889, 17901, 17920, 17921, 17922, 17923, 17925, 17927, 17929, 17930, 17931, 17932, 17933, 17934, 17935, 17936, 17938, 17941, 17942, 17943, 17944, 17945, 17946, 17948, 17949, 17951, 17952, 17953, 17954, 17957, 17959, 17960, 17961, 17963, 17964, 17965, 17966, 17967, 17968, 17970, 17972, 17974, 17976, 17978, 17979, 17980, 17981, 17982, 17983, 17985, 18001, 18002, 18003, 18010, 18011, 18012, 18013, 18014, 18015, 18016, 18017, 18018, 18020, 18021, 18024, 18025, 18030, 18031, 18032, 18034, 18035, 18036, 18037, 18038, 18039, 18040, 18041, 18042, 18043, 18044, 18045, 18046, 18049, 18050, 18051, 18052, 18053, 18054, 18055, 18056, 18058, 18059, 18060, 18062, 18063, 18064, 18065, 18066, 18067, 18068, 18069, 18070, 18071, 18072, 18073, 18074, 18076, 18077, 18078, 18079, 18080, 18081, 18083, 18084, 18085, 18086, 18087, 18088, 18091, 18092, 18096, 18098, 18099, 18101, 18102, 18103, 18104, 18105, 18106, 18109, 18160, 18175, 18195, 18201, 18202, 18210, 18211, 18212, 18214, 18216, 18218, 18219, 18220, 18221, 18222, 18223, 18224, 18225, 18229, 18230, 18231, 18232, 18234, 18235, 18237, 18239, 18240, 18241, 18242, 18243, 18244, 18245, 18246, 18247, 18248, 18249, 18250, 18251, 18252, 18254, 18255, 18256, 18301, 18320, 18321, 18322, 18323, 18324, 18325, 18326, 18327, 18328, 18330, 18331, 18332, 18333, 18334, 18335, 18336, 18337, 18340, 18341, 18342, 18343, 18344, 18346, 18347, 18348, 18349, 18350, 18351, 18352, 18353, 18354, 18355, 18356, 18357, 18360, 18370, 18371, 18372, 18373, 18377, 18401, 18403, 18405, 18407, 18410, 18411, 18413, 18414, 18416, 18419, 18420, 18421, 18424, 18425, 18426, 18427, 18428, 18431, 18433, 18434, 18435, 18436, 18438, 18440, 18441, 18443, 18444, 18445, 18446, 18447, 18448, 18449, 18451, 18452, 18454, 18456, 18457, 18458, 18459, 18460, 18463, 18464, 18466, 18470, 18471, 18472, 18473, 18501, 18502, 18503, 18504, 18505, 18507, 18508, 18509, 18510, 18512, 18514, 18515, 18517, 18518, 18519, 18522, 18540, 18577, 18601, 18602, 18603, 18610, 18611, 18612, 18614, 18615, 18616, 18617, 18618, 18619, 18621, 18622, 18623, 18624, 18625, 18626, 18627, 18628, 18629, 18630, 18631, 18632, 18634, 18635, 18636, 18638, 18640, 18641, 18642, 18643, 18644, 18651, 18653, 18654, 18655, 18656, 18657, 18660, 18661, 18672, 18690, 18701, 18702, 18703, 18704, 18705, 18706, 18707, 18708, 18709, 18710, 18711, 18715, 18761, 18762, 18763, 18764, 18765, 18766, 18767, 18768, 18769, 18773, 18774, 18813, 18816, 18824, 18826, 18833, 18842, 18844, 18846, 18901, 18903, 18910, 18911, 18912, 18913, 18914, 18915, 18916, 18917, 18918, 18920, 18921, 18922, 18923, 18924, 18925, 18926, 18927, 18928, 18929, 18930, 18931, 18932, 18933, 18934, 18935, 18936, 18938, 18940, 18942, 18943, 18944, 18945, 18946, 18947, 18949, 18950, 18951, 18953, 18954, 18955, 18956, 18957, 18958, 18960, 18962, 18963, 18964, 18966, 18968, 18969, 18970, 18971, 18972, 18974, 18976, 18977, 18979, 18980, 18981, 18991, 19001, 19002, 19003, 19004, 19006, 19007, 19008, 19009, 19010, 19012, 19013, 19014, 19015, 19016, 19017, 19018, 19019, 19020, 19021, 19022, 19023, 19025, 19026, 19027, 19028, 19029, 19030, 19031, 19032, 19033, 19034, 19035, 19036, 19037, 19038, 19039, 19040, 19041, 19043, 19044, 19046, 19047, 19048, 19049, 19050, 19052, 19053, 19054, 19055, 19056, 19057, 19058, 19059, 19061, 19063, 19064, 19065, 19066, 19067, 19070, 19072, 19073, 19074, 19075, 19076, 19078, 19079, 19080, 19081, 19082, 19083, 19085, 19086, 19087, 19088, 19089, 19090, 19091, 19092, 19093, 19094, 19095, 19096, 19098, 19099, 19101, 19102, 19103, 19104, 19105, 19106, 19107, 19108, 19109, 19110, 19111, 19112, 19113, 19114, 19115, 19116, 19118, 19119, 19120, 19121, 19122, 19123, 19124, 19125, 19126, 19127, 19128, 19129, 19130, 19131, 19132, 19133, 19134, 19135, 19136, 19137, 19138, 19139, 19140, 19141, 19142, 19143, 19144, 19145, 19146, 19147, 19148, 19149, 19150, 19151, 19152, 19153, 19154, 19155, 19156, 19160, 19161, 19162, 19170, 19171, 19172, 19173, 19175, 19177, 19178, 19179, 19181, 19182, 19183, 19184, 19185, 19187, 19188, 19191, 19192, 19193, 19194, 19196, 19197, 19244, 19255, 19301, 19310, 19311, 19312, 19316, 19317, 19318, 19319, 19320, 19330, 19331, 19333, 19335, 19339, 19340, 19341, 19342, 19343, 19344, 19345, 19346, 19347, 19348, 19350, 19351, 19352, 19353, 19354, 19355, 19357, 19358, 19360, 19362, 19363, 19365, 19366, 19367, 19369, 19370, 19371, 19372, 19373, 19374, 19375, 19376, 19380, 19381, 19382, 19383, 19390, 19395, 19397, 19398, 19399, 19401, 19403, 19404, 19405, 19406, 19407, 19408, 19409, 19420, 19421, 19422, 19423, 19424, 19425, 19426, 19428, 19429, 19430, 19432, 19435, 19436, 19437, 19438, 19440, 19441, 19442, 19443, 19444, 19446, 19450, 19451, 19452, 19453, 19454, 19455, 19456, 19457, 19460, 19462, 19464, 19465, 19468, 19470, 19472, 19473, 19474, 19475, 19477, 19478, 19480, 19481, 19482, 19483, 19484, 19485, 19486, 19487, 19488, 19489, 19490, 19492, 19493, 19494, 19495, 19496, 19501, 19503, 19504, 19505, 19506, 19507, 19508, 19510, 19511, 19512, 19516, 19517, 19518, 19519, 19520, 19522, 19523, 19524, 19525, 19526, 19529, 19530, 19533, 19534, 19535, 19536, 19538, 19539, 19540, 19541, 19542, 19543, 19544, 19545, 19546, 19547, 19548, 19549, 19550, 19551, 19554, 19555, 19557, 19559, 19560, 19562, 19564, 19565, 19567, 19601, 19602, 19603, 19604, 19605, 19606, 19607, 19608, 19609, 19610, 19611, 19612, 19640, 19650, 19685, 19700, 19701, 19702, 19703, 19706, 19707, 19708, 19709, 19710, 19711, 19712, 19713, 19714, 19715, 19716, 19717, 19718, 19720, 19721, 19725, 19726, 19730, 19731, 19732, 19733, 19734, 19735, 19736, 19743, 19766, 19801, 19802, 19803, 19804, 19805, 19806, 19807, 19808, 19809, 19810, 19814, 19815, 19850, 19853, 19880, 19884, 19885, 19886, 19887, 19889, 19890, 19891, 19892, 19893, 19894, 19895, 19896, 19897, 19898, 19899, 19901, 19902, 19903, 19904, 19905, 19925, 19934, 19936, 19938, 19943, 19946, 19952, 19953, 19954, 19955, 19961, 19962, 19963, 19964, 19977, 19979, 19980, 20701, 20755, 20763, 20794, 21001, 21002, 21004, 21005, 21009, 21010, 21012, 21013, 21014, 21015, 21017, 21018, 21020, 21022, 21023, 21027, 21028, 21029, 21030, 21031, 21032, 21034, 21036, 21040, 21041, 21042, 21043, 21044, 21045, 21046, 21047, 21048, 21050, 21051, 21052, 21053, 21055, 21056, 21057, 21060, 21061, 21071, 21074, 21075, 21076, 21077, 21078, 21080, 21082, 21084, 21085, 21087, 21088, 21090, 21092, 21093, 21094, 21102, 21104, 21105, 21108, 21111, 21113, 21117, 21120, 21122, 21128, 21130, 21131, 21132, 21133, 21136, 21139, 21144, 21146, 21150, 21152, 21153, 21154, 21155, 21156, 21157, 21158, 21160, 21161, 21162, 21163, 21176, 21201, 21202, 21203, 21204, 21205, 21206, 21207, 21208, 21209, 21210, 21211, 21212, 21213, 21214, 21215, 21216, 21217, 21218, 21219, 21220, 21221, 21222, 21223, 21224, 21225, 21226, 21227, 21228, 21229, 21230, 21231, 21233, 21234, 21235, 21236, 21237, 21239, 21240, 21241, 21244, 21250, 21251, 21252, 21260, 21263, 21264, 21265, 21268, 21270, 21273, 21274, 21275, 21278, 21279, 21280, 21281, 21282, 21283, 21284, 21285, 21286, 21287, 21288, 21289, 21290, 21297, 21298, 21401, 21402, 21405, 21607, 21610, 21617, 21619, 21620, 21623, 21625, 21628, 21635, 21636, 21638, 21639, 21640, 21641, 21644, 21645, 21649, 21650, 21651, 21656, 21657, 21658, 21660, 21661, 21666, 21667, 21668, 21670, 21678, 21679, 21681, 21682, 21683, 21684, 21685, 21686, 21687, 21688, 21690, 21723, 21727, 21737, 21738, 21757, 21759, 21762, 21764, 21765, 21771, 21775, 21776, 21778, 21784, 21787, 21791, 21794, 21797, 21798, 21901, 21902, 21903, 21904, 21911, 21912, 21913, 21914, 21915, 21916, 21917, 21918, 21919, 21920, 21921, 21922, 21930)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
