| |
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 + user_session_time / 1227028856 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1130 and user_zip in (7820, 7823, 7825, 7829, 7830, 7831, 7832, 7833, 7838, 7840, 7841, 7844, 7846, 7853, 7863, 7865, 7870, 7875, 7880, 7882, 7979, 8001, 8002, 8003, 8004, 8007, 8009, 8010, 8011, 8012, 8014, 8016, 8018, 8020, 8021, 8022, 8023, 8025, 8026, 8027, 8028, 8029, 8030, 8031, 8032, 8033, 8034, 8035, 8036, 8038, 8039, 8041, 8043, 8045, 8046, 8048, 8049, 8051, 8052, 8053, 8054, 8055, 8056, 8057, 8059, 8060, 8061, 8062, 8063, 8065, 8066, 8067, 8069, 8070, 8071, 8072, 8073, 8074, 8075, 8077, 8078, 8079, 8080, 8081, 8083, 8084, 8085, 8086, 8089, 8090, 8091, 8093, 8094, 8096, 8097, 8098, 8099, 8101, 8102, 8103, 8104, 8105, 8106, 8107, 8108, 8109, 8110, 8253, 8302, 8311, 8312, 8313, 8318, 8320, 8322, 8323, 8328, 8343, 8344, 8347, 8352, 8353, 8360, 8504, 8505, 8518, 8525, 8530, 8534, 8540, 8541, 8542, 8543, 8544, 8551, 8553, 8554, 8556, 8557, 8558, 8559, 8560, 8601, 8602, 8603, 8604, 8605, 8606, 8607, 8608, 8609, 8610, 8611, 8618, 8619, 8620, 8625, 8628, 8629, 8638, 8645, 8646, 8647, 8648, 8650, 8666, 8677, 8690, 8695, 8801, 8802, 8803, 8804, 8808, 8809, 8821, 8822, 8825, 8826, 8827, 8829, 8833, 8834, 8844, 8848, 8851, 8853, 8858, 8865, 8867, 8868, 8870, 8875, 8885, 8886, 8887, 8888, 8889, 15533, 15536, 15537, 16601, 16602, 16603, 16611, 16614, 16617, 16621, 16622, 16623, 16631, 16633, 16634, 16637, 16638, 16647, 16648, 16650, 16652, 16654, 16657, 16659, 16660, 16662, 16664, 16666, 16669, 16672, 16673, 16674, 16677, 16678, 16679, 16683, 16684, 16685, 16686, 16689, 16691, 16693, 16694, 16695, 16801, 16802, 16803, 16804, 16805, 16815, 16820, 16822, 16823, 16826, 16827, 16828, 16829, 16832, 16834, 16835, 16839, 16840, 16841, 16844, 16845, 16847, 16848, 16849, 16851, 16852, 16853, 16854, 16856, 16858, 16859, 16860, 16864, 16865, 16866, 16868, 16870, 16871, 16872, 16874, 16875, 16877, 16879, 16882, 16910, 16911, 16912, 16926, 16930, 16938, 16939, 16945, 16947, 17001, 17002, 17003, 17004, 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, 17051, 17052, 17053, 17054, 17055, 17056, 17057, 17058, 17059, 17060, 17061, 17062, 17063, 17064, 17065, 17066, 17067, 17068, 17069, 17070, 17071, 17072, 17073, 17074, 17075, 17076, 17077, 17078, 17080, 17081, 17082, 17083, 17084, 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, 17201, 17210, 17212, 17213, 17214, 17215, 17217, 17219, 17220, 17221, 17222, 17223, 17224, 17225, 17228, 17229, 17231, 17232, 17233, 17235, 17236, 17237, 17238, 17239, 17240, 17241, 17243, 17244, 17246, 17247, 17249, 17250, 17251, 17252, 17253, 17254, 17255, 17256, 17257, 17260, 17261, 17262, 17263, 17264, 17265, 17266, 17267, 17268, 17269, 17270, 17271, 17272, 17275, 17294, 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, 17721, 17722, 17723, 17724, 17726, 17727, 17728, 17730, 17731, 17735, 17737, 17738, 17739, 17740, 17741, 17742, 17743, 17744, 17745, 17747, 17748, 17749, 17750, 17751, 17752, 17754, 17756, 17757, 17758, 17759, 17760, 17762, 17763, 17764, 17765, 17767, 17768, 17769, 17771, 17772, 17773, 17774, 17776, 17777, 17778, 17779, 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, 18330, 18331, 18332, 18333, 18334, 18335, 18341, 18342, 18343, 18344, 18346, 18347, 18348, 18349, 18350, 18351, 18352, 18353, 18354, 18355, 18356, 18357, 18360, 18370, 18372, 18403, 18410, 18411, 18414, 18416, 18419, 18420, 18424, 18426, 18427, 18433, 18434, 18436, 18440, 18444, 18445, 18446, 18447, 18448, 18451, 18452, 18460, 18463, 18466, 18471, 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, 18814, 18815, 18832, 18833, 18844, 18846, 18848, 18853, 18854, 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, 19904, 19925, 19934, 19936, 19938, 19953, 19955, 19961, 19964, 19977, 20011, 20012, 20015, 20176, 20180, 20197, 20701, 20705, 20706, 20707, 20708, 20710, 20712, 20715, 20716, 20720, 20721, 20722, 20723, 20724, 20737, 20740, 20755, 20759, 20763, 20769, 20770, 20777, 20781, 20782, 20783, 20784, 20787, 20788, 20794, 20813, 20814, 20815, 20817, 20824, 20825, 20827, 20830, 20832, 20833, 20837, 20838, 20839, 20841, 20842, 20847, 20848, 20849, 20850, 20851, 20852, 20853, 20854, 20855, 20857, 20859, 20860, 20861, 20862, 20866, 20868, 20871, 20872, 20874, 20875, 20876, 20877, 20878, 20879, 20880, 20882, 20884, 20885, 20886, 20889, 20891, 20892, 20894, 20895, 20896, 20897, 20898, 20899, 20901, 20902, 20903, 20904, 20905, 20906, 20907, 20908, 20910, 20911, 20912, 20914, 20915, 20916, 20918, 20997, 21001, 21002, 21004, 21005, 21009, 21010, 21012, 21013, 21014, 21015, 21017, 21018, 21020, 21022, 21023, 21027, 21028, 21029, 21030, 21031, 21032, 21034, 21035, 21036, 21037, 21040, 21041, 21042, 21043, 21044, 21045, 21046, 21047, 21048, 21050, 21051, 21052, 21053, 21054, 21055, 21056, 21057, 21060, 21061, 21062, 21071, 21074, 21075, 21076, 21077, 21078, 21080, 21082, 21084, 21085, 21087, 21088, 21090, 21092, 21093, 21094, 21098, 21102, 21104, 21105, 21106, 21108, 21111, 21113, 21114, 21117, 21120, 21122, 21123, 21128, 21130, 21131, 21132, 21133, 21136, 21139, 21140, 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, 21403, 21404, 21405, 21411, 21412, 21607, 21610, 21617, 21619, 21620, 21623, 21628, 21635, 21636, 21638, 21640, 21644, 21645, 21649, 21650, 21651, 21656, 21658, 21661, 21666, 21667, 21668, 21678, 21690, 21701, 21702, 21703, 21704, 21705, 21709, 21710, 21711, 21713, 21714, 21715, 21716, 21717, 21718, 21719, 21720, 21721, 21722, 21723, 21727, 21733, 21734, 21736, 21737, 21738, 21740, 21741, 21742, 21746, 21747, 21748, 21749, 21750, 21754, 21755, 21756, 21757, 21758, 21759, 21762, 21764, 21765, 21767, 21769, 21770, 21771, 21773, 21774, 21775, 21776, 21777, 21778, 21779, 21780, 21781, 21782, 21783, 21784, 21787, 21788, 21790, 21791, 21792, 21793, 21794, 21795, 21797, 21798, 21901, 21902, 21903, 21904, 21911, 21912, 21913, 21914, 21915, 21916, 21917, 21918, 21919, 21920, 21921, 21922, 21930, 25401, 25402, 25419, 25425, 25427, 25429, 25442, 25443, 25543)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
