| |
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 / 329 * 10) + user_session_time / 1227028642 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1050 and user_zip in (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, 7721, 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, 8502, 8504, 8512, 8520, 8525, 8528, 8530, 8534, 8536, 8540, 8541, 8542, 8543, 8544, 8550, 8551, 8553, 8556, 8557, 8558, 8559, 8560, 8561, 8570, 8601, 8602, 8603, 8604, 8605, 8606, 8607, 8608, 8609, 8610, 8611, 8618, 8619, 8625, 8628, 8629, 8638, 8645, 8646, 8647, 8648, 8650, 8666, 8677, 8690, 8695, 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, 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, 10466, 10467, 10468, 10469, 10470, 10471, 10472, 10473, 10474, 10475, 10499, 10501, 10502, 10503, 10504, 10505, 10507, 10510, 10511, 10512, 10514, 10516, 10517, 10519, 10520, 10521, 10522, 10523, 10524, 10526, 10527, 10530, 10532, 10533, 10535, 10536, 10537, 10540, 10541, 10542, 10545, 10546, 10547, 10548, 10549, 10550, 10551, 10552, 10553, 10557, 10558, 10559, 10562, 10566, 10567, 10570, 10571, 10572, 10577, 10578, 10579, 10581, 10583, 10586, 10587, 10588, 10589, 10591, 10592, 10594, 10595, 10596, 10598, 10601, 10602, 10603, 10604, 10605, 10606, 10607, 10610, 10625, 10629, 10633, 10701, 10702, 10703, 10704, 10705, 10706, 10707, 10708, 10709, 10710, 10730, 10801, 10802, 10803, 10804, 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, 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, 11101, 11102, 11103, 11104, 11105, 11106, 11201, 11205, 11206, 11209, 11211, 11215, 11217, 11219, 11220, 11222, 11228, 11231, 11232, 11238, 11286, 11370, 11371, 11377, 11517, 12036, 12043, 12064, 12071, 12073, 12076, 12093, 12116, 12120, 12122, 12131, 12149, 12155, 12167, 12175, 12187, 12194, 12197, 12401, 12402, 12404, 12405, 12406, 12407, 12409, 12410, 12411, 12412, 12413, 12414, 12416, 12417, 12418, 12419, 12420, 12421, 12422, 12423, 12424, 12427, 12428, 12429, 12430, 12431, 12432, 12433, 12434, 12435, 12436, 12438, 12439, 12440, 12441, 12442, 12443, 12444, 12446, 12447, 12448, 12449, 12450, 12451, 12452, 12453, 12454, 12455, 12456, 12457, 12458, 12459, 12460, 12461, 12463, 12464, 12465, 12466, 12468, 12469, 12470, 12471, 12472, 12473, 12474, 12475, 12477, 12480, 12481, 12482, 12483, 12484, 12485, 12486, 12487, 12489, 12490, 12491, 12492, 12493, 12494, 12495, 12496, 12498, 12504, 12506, 12507, 12508, 12509, 12510, 12511, 12512, 12514, 12515, 12518, 12520, 12524, 12525, 12526, 12527, 12528, 12531, 12533, 12537, 12538, 12540, 12542, 12543, 12545, 12547, 12548, 12549, 12550, 12551, 12552, 12553, 12555, 12557, 12561, 12566, 12568, 12569, 12570, 12571, 12572, 12574, 12575, 12577, 12578, 12580, 12581, 12582, 12583, 12584, 12585, 12586, 12588, 12589, 12590, 12601, 12602, 12603, 12604, 12701, 12710, 12719, 12720, 12721, 12722, 12723, 12724, 12725, 12726, 12727, 12729, 12732, 12733, 12734, 12736, 12737, 12738, 12739, 12740, 12741, 12742, 12743, 12745, 12746, 12747, 12748, 12749, 12750, 12751, 12752, 12754, 12756, 12758, 12759, 12760, 12762, 12763, 12764, 12765, 12766, 12767, 12768, 12769, 12770, 12771, 12775, 12776, 12777, 12778, 12779, 12780, 12781, 12782, 12783, 12784, 12785, 12786, 12787, 12788, 12789, 12790, 12791, 12792, 12793, 12938, 13020, 13040, 13045, 13051, 13052, 13053, 13056, 13061, 13062, 13063, 13068, 13071, 13072, 13073, 13077, 13081, 13087, 13092, 13101, 13102, 13118, 13122, 13124, 13129, 13133, 13136, 13138, 13141, 13149, 13155, 13158, 13159, 13310, 13313, 13314, 13315, 13320, 13326, 13332, 13334, 13335, 13337, 13342, 13346, 13348, 13355, 13396, 13402, 13408, 13411, 13415, 13418, 13439, 13444, 13450, 13455, 13457, 13460, 13464, 13468, 13480, 13482, 13484, 13485, 13488, 13491, 13578, 13730, 13731, 13732, 13733, 13734, 13736, 13737, 13738, 13739, 13740, 13743, 13744, 13745, 13746, 13747, 13748, 13749, 13750, 13751, 13752, 13753, 13754, 13755, 13756, 13757, 13758, 13760, 13761, 13762, 13763, 13766, 13774, 13775, 13776, 13777, 13778, 13780, 13782, 13783, 13784, 13786, 13787, 13788, 13790, 13792, 13794, 13795, 13796, 13797, 13801, 13802, 13803, 13804, 13806, 13807, 13808, 13809, 13810, 13811, 13812, 13813, 13814, 13815, 13820, 13825, 13826, 13827, 13830, 13832, 13833, 13834, 13835, 13837, 13838, 13839, 13840, 13841, 13842, 13843, 13844, 13845, 13846, 13847, 13848, 13849, 13850, 13851, 13856, 13859, 13860, 13861, 13862, 13863, 13864, 13865, 13901, 13902, 13903, 13904, 13905, 14801, 14805, 14812, 14814, 14816, 14817, 14818, 14821, 14824, 14825, 14827, 14830, 14838, 14841, 14844, 14845, 14847, 14850, 14851, 14852, 14853, 14854, 14858, 14859, 14861, 14863, 14864, 14865, 14867, 14869, 14870, 14871, 14872, 14876, 14878, 14881, 14882, 14883, 14886, 14887, 14889, 14891, 14892, 14894, 14901, 14902, 14903, 14904, 14905, 14925, 16901, 16910, 16911, 16912, 16914, 16917, 16920, 16925, 16926, 16929, 16930, 16932, 16933, 16935, 16936, 16938, 16939, 16940, 16942, 16945, 16946, 16947, 17003, 17005, 17010, 17016, 17017, 17023, 17026, 17028, 17030, 17032, 17038, 17039, 17042, 17045, 17046, 17048, 17061, 17064, 17067, 17073, 17077, 17078, 17080, 17083, 17085, 17086, 17087, 17088, 17097, 17098, 17128, 17501, 17506, 17507, 17517, 17519, 17521, 17522, 17533, 17543, 17549, 17555, 17557, 17567, 17569, 17578, 17581, 17701, 17702, 17703, 17705, 17720, 17721, 17722, 17723, 17724, 17727, 17728, 17730, 17731, 17735, 17737, 17739, 17740, 17741, 17742, 17743, 17744, 17747, 17748, 17749, 17752, 17754, 17756, 17757, 17758, 17759, 17762, 17763, 17765, 17768, 17769, 17771, 17772, 17774, 17776, 17777, 17779, 17786, 17801, 17810, 17813, 17814, 17815, 17820, 17821, 17822, 17823, 17824, 17825, 17827, 17828, 17829, 17830, 17831, 17832, 17833, 17834, 17835, 17836, 17837, 17839, 17840, 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, 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, 18415, 18416, 18417, 18419, 18420, 18421, 18424, 18425, 18426, 18427, 18428, 18430, 18431, 18433, 18434, 18435, 18436, 18437, 18438, 18439, 18440, 18441, 18443, 18444, 18445, 18446, 18447, 18448, 18449, 18451, 18452, 18453, 18454, 18455, 18456, 18457, 18458, 18459, 18460, 18461, 18462, 18463, 18464, 18465, 18466, 18469, 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, 18801, 18810, 18812, 18813, 18814, 18815, 18816, 18817, 18818, 18820, 18821, 18822, 18823, 18824, 18825, 18826, 18827, 18828, 18829, 18830, 18831, 18832, 18833, 18834, 18837, 18839, 18840, 18842, 18843, 18844, 18845, 18846, 18847, 18848, 18850, 18851, 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, 19006, 19009, 19025, 19030, 19031, 19034, 19038, 19040, 19044, 19046, 19047, 19048, 19049, 19053, 19054, 19055, 19056, 19057, 19058, 19059, 19067, 19075, 19087, 19090, 19095, 19116, 19118, 19156, 19343, 19344, 19354, 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, 19490, 19492, 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, 19743, 19815, 19853, 19925)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
