| |
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 / 1 * 10) + user_session_time / 1227046837 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1060 and user_zip in (27013, 27014, 27054, 27144, 28003, 28006, 28010, 28012, 28016, 28017, 28018, 28019, 28020, 28021, 28023, 28024, 28025, 28026, 28027, 28031, 28032, 28033, 28034, 28036, 28037, 28038, 28039, 28040, 28041, 28042, 28043, 28051, 28052, 28053, 28054, 28055, 28056, 28070, 28071, 28072, 28073, 28074, 28075, 28076, 28077, 28078, 28079, 28080, 28081, 28082, 28083, 28086, 28088, 28089, 28090, 28092, 28093, 28097, 28098, 28101, 28103, 28104, 28105, 28106, 28107, 28108, 28109, 28110, 28111, 28112, 28114, 28115, 28117, 28120, 28123, 28124, 28125, 28126, 28129, 28130, 28133, 28134, 28135, 28136, 28138, 28139, 28144, 28145, 28146, 28147, 28150, 28151, 28152, 28159, 28160, 28163, 28164, 28166, 28167, 28168, 28169, 28173, 28174, 28201, 28202, 28203, 28204, 28205, 28206, 28207, 28208, 28209, 28210, 28211, 28212, 28213, 28214, 28215, 28216, 28217, 28218, 28219, 28220, 28221, 28222, 28223, 28224, 28225, 28226, 28227, 28228, 28229, 28230, 28231, 28232, 28233, 28234, 28235, 28236, 28237, 28240, 28241, 28242, 28243, 28244, 28246, 28247, 28250, 28253, 28254, 28255, 28256, 28258, 28260, 28261, 28262, 28265, 28266, 28269, 28270, 28272, 28273, 28274, 28275, 28277, 28278, 28280, 28281, 28282, 28283, 28284, 28285, 28286, 28287, 28288, 28289, 28290, 28296, 28297, 28299, 28559, 28601, 28602, 28603, 28604, 28605, 28606, 28607, 28608, 28609, 28610, 28611, 28612, 28613, 28616, 28618, 28619, 28620, 28622, 28624, 28625, 28626, 28628, 28629, 28630, 28633, 28634, 28636, 28637, 28638, 28641, 28645, 28646, 28647, 28650, 28651, 28652, 28653, 28654, 28655, 28657, 28658, 28659, 28660, 28661, 28662, 28664, 28665, 28666, 28667, 28671, 28673, 28674, 28677, 28678, 28679, 28680, 28681, 28682, 28684, 28687, 28688, 28689, 28690, 28691, 28692, 28697, 28698, 28699, 28701, 28702, 28704, 28705, 28707, 28708, 28709, 28710, 28711, 28712, 28713, 28714, 28715, 28716, 28717, 28718, 28719, 28720, 28721, 28722, 28723, 28724, 28725, 28726, 28727, 28728, 28729, 28730, 28731, 28732, 28734, 28735, 28736, 28737, 28738, 28739, 28740, 28741, 28742, 28743, 28744, 28745, 28746, 28747, 28748, 28749, 28750, 28751, 28752, 28753, 28754, 28755, 28756, 28757, 28758, 28760, 28761, 28762, 28763, 28765, 28766, 28767, 28768, 28770, 28772, 28773, 28774, 28775, 28776, 28777, 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, 28971, 28972, 29002, 29006, 29009, 29014, 29015, 29016, 29020, 29031, 29032, 29033, 29036, 29037, 29044, 29045, 29053, 29054, 29055, 29058, 29061, 29063, 29065, 29066, 29067, 29070, 29071, 29072, 29073, 29074, 29075, 29078, 29105, 29106, 29108, 29122, 29123, 29124, 29126, 29127, 29128, 29129, 29130, 29132, 29138, 29145, 29147, 29160, 29164, 29166, 29169, 29170, 29171, 29172, 29175, 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, 29718, 29720, 29721, 29722, 29724, 29726, 29727, 29728, 29729, 29730, 29731, 29732, 29733, 29734, 29741, 29742, 29743, 29744, 29745, 29801, 29802, 29805, 29819, 29821, 29824, 29828, 29829, 29832, 29835, 29838, 29840, 29844, 29845, 29847, 29848, 29850, 29851, 29860, 29899, 30511, 30516, 30520, 30521, 30523, 30525, 30530, 30531, 30535, 30537, 30538, 30544, 30547, 30552, 30553, 30557, 30562, 30563, 30568, 30573, 30576, 30577, 30580, 30581, 30596, 30598, 30624, 30627, 30628, 30629, 30633, 30634, 30635, 30639, 30643, 30647, 30662, 30668, 30673, 30802, 30809, 30817, 37601, 37602, 37604, 37605, 37614, 37616, 37640, 37641, 37643, 37650, 37657, 37658, 37659, 37681, 37682, 37684, 37687, 37690, 37691, 37692, 37694, 37722, 37727, 37743, 37744, 37753, 37822, 37843)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
