| |
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 / 8 * 10) + user_session_time / 1227046853 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1070 and user_zip in (28016, 28017, 28018, 28019, 28020, 28021, 28024, 28032, 28033, 28034, 28038, 28040, 28042, 28043, 28051, 28052, 28053, 28054, 28055, 28056, 28073, 28074, 28076, 28086, 28089, 28090, 28098, 28101, 28114, 28136, 28139, 28150, 28151, 28152, 28160, 28167, 28169, 28278, 28701, 28704, 28707, 28708, 28709, 28710, 28711, 28712, 28713, 28715, 28716, 28717, 28718, 28719, 28720, 28721, 28722, 28723, 28724, 28725, 28726, 28727, 28728, 28729, 28730, 28731, 28732, 28734, 28735, 28736, 28737, 28738, 28739, 28741, 28742, 28744, 28745, 28746, 28747, 28748, 28750, 28751, 28752, 28756, 28757, 28758, 28760, 28761, 28762, 28763, 28766, 28767, 28768, 28770, 28772, 28773, 28774, 28775, 28776, 28778, 28779, 28781, 28782, 28783, 28784, 28785, 28786, 28787, 28788, 28789, 28790, 28791, 28792, 28793, 28796, 28800, 28801, 28802, 28803, 28804, 28805, 28806, 28808, 28810, 28813, 28814, 28815, 28816, 28904, 28909, 28971, 28972, 29002, 29006, 29014, 29015, 29016, 29031, 29033, 29036, 29037, 29042, 29045, 29053, 29054, 29055, 29058, 29061, 29063, 29065, 29066, 29070, 29071, 29072, 29073, 29074, 29075, 29078, 29105, 29106, 29107, 29108, 29112, 29113, 29122, 29123, 29124, 29126, 29127, 29129, 29130, 29132, 29137, 29138, 29145, 29146, 29147, 29160, 29164, 29166, 29169, 29170, 29171, 29172, 29176, 29177, 29178, 29180, 29201, 29202, 29203, 29204, 29205, 29206, 29207, 29208, 29209, 29210, 29211, 29212, 29214, 29215, 29216, 29217, 29218, 29219, 29220, 29221, 29222, 29223, 29224, 29225, 29226, 29227, 29228, 29229, 29230, 29233, 29235, 29240, 29250, 29260, 29290, 29292, 29301, 29302, 29303, 29304, 29305, 29306, 29307, 29316, 29318, 29319, 29320, 29321, 29322, 29323, 29324, 29325, 29329, 29330, 29331, 29332, 29333, 29334, 29335, 29336, 29338, 29340, 29341, 29342, 29346, 29348, 29349, 29351, 29353, 29355, 29356, 29360, 29364, 29365, 29368, 29369, 29370, 29372, 29373, 29374, 29375, 29376, 29377, 29378, 29379, 29384, 29385, 29386, 29388, 29390, 29391, 29535, 29601, 29602, 29603, 29604, 29605, 29606, 29607, 29608, 29609, 29610, 29611, 29612, 29613, 29614, 29615, 29616, 29617, 29620, 29621, 29622, 29623, 29624, 29625, 29626, 29627, 29628, 29630, 29631, 29632, 29633, 29634, 29635, 29636, 29638, 29639, 29640, 29641, 29642, 29643, 29644, 29645, 29646, 29647, 29648, 29649, 29650, 29651, 29652, 29653, 29654, 29655, 29656, 29657, 29658, 29659, 29661, 29662, 29664, 29665, 29666, 29667, 29669, 29670, 29671, 29672, 29673, 29675, 29676, 29677, 29678, 29679, 29680, 29681, 29682, 29683, 29684, 29685, 29686, 29687, 29688, 29689, 29690, 29691, 29692, 29693, 29695, 29696, 29697, 29698, 29702, 29703, 29704, 29706, 29708, 29710, 29712, 29714, 29715, 29716, 29717, 29720, 29721, 29724, 29726, 29729, 29730, 29731, 29732, 29733, 29734, 29742, 29743, 29744, 29745, 29801, 29802, 29803, 29804, 29805, 29808, 29809, 29812, 29813, 29816, 29817, 29819, 29821, 29822, 29824, 29826, 29828, 29829, 29831, 29832, 29834, 29835, 29838, 29839, 29840, 29841, 29842, 29844, 29845, 29847, 29848, 29850, 29851, 29853, 29856, 29860, 29861, 29899, 30003, 30010, 30011, 30014, 30015, 30017, 30018, 30019, 30024, 30025, 30026, 30028, 30029, 30039, 30041, 30043, 30044, 30045, 30046, 30048, 30052, 30054, 30055, 30056, 30070, 30078, 30091, 30098, 30413, 30426, 30434, 30456, 30501, 30502, 30503, 30504, 30505, 30506, 30507, 30510, 30511, 30512, 30515, 30516, 30517, 30518, 30519, 30520, 30521, 30523, 30525, 30527, 30528, 30529, 30530, 30531, 30533, 30534, 30535, 30537, 30538, 30542, 30543, 30544, 30545, 30546, 30547, 30548, 30549, 30552, 30553, 30554, 30557, 30558, 30562, 30563, 30564, 30565, 30566, 30567, 30568, 30571, 30572, 30573, 30575, 30576, 30577, 30580, 30581, 30582, 30596, 30597, 30598, 30599, 30601, 30602, 30603, 30604, 30605, 30606, 30607, 30608, 30609, 30610, 30612, 30613, 30619, 30620, 30621, 30622, 30623, 30624, 30625, 30627, 30628, 30629, 30630, 30631, 30633, 30634, 30635, 30638, 30639, 30641, 30642, 30643, 30645, 30646, 30647, 30648, 30650, 30652, 30655, 30656, 30660, 30662, 30663, 30664, 30665, 30666, 30667, 30668, 30669, 30671, 30673, 30677, 30678, 30680, 30683, 30802, 30803, 30805, 30806, 30807, 30808, 30809, 30810, 30811, 30812, 30813, 30814, 30815, 30816, 30817, 30818, 30819, 30820, 30821, 30823, 30824, 30828, 30830, 30833, 30901, 30903, 30904, 30905, 30906, 30907, 30909, 30910, 30911, 30912, 30913, 30914, 30916, 30917, 30919, 30999, 31018, 31024, 31045, 31061, 31062, 31082, 31085, 31087, 31094)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
