| |
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 / 2 * 10) + user_session_time / 1227031803 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1>1500 and user_zip in (27006, 27010, 27011, 27012, 27013, 27014, 27018, 27020, 27023, 27028, 27040, 27054, 27055, 27094, 27098, 27099, 27101, 27102, 27103, 27104, 27105, 27106, 27107, 27108, 27109, 27110, 27111, 27113, 27114, 27115, 27116, 27117, 27120, 27127, 27130, 27144, 27150, 27151, 27152, 27155, 27156, 27157, 27198, 27199, 27203, 27204, 27205, 27208, 27209, 27229, 27230, 27239, 27242, 27247, 27248, 27259, 27260, 27261, 27262, 27263, 27264, 27265, 27281, 27282, 27285, 27292, 27293, 27294, 27295, 27299, 27306, 27316, 27317, 27325, 27341, 27350, 27351, 27356, 27360, 27361, 27370, 27371, 27373, 27374, 27376, 27391, 27404, 27411, 27413, 27415, 27416, 27417, 27419, 27425, 27427, 27429, 27435, 27438, 27480, 27495, 27498, 27499, 27630, 28001, 28002, 28003, 28006, 28007, 28009, 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, 28091, 28092, 28093, 28097, 28098, 28101, 28102, 28103, 28104, 28105, 28106, 28107, 28108, 28109, 28110, 28111, 28112, 28114, 28115, 28117, 28119, 28120, 28123, 28124, 28125, 28126, 28127, 28128, 28129, 28130, 28133, 28134, 28135, 28136, 28137, 28138, 28139, 28144, 28145, 28146, 28147, 28150, 28151, 28152, 28159, 28160, 28163, 28164, 28166, 28167, 28168, 28169, 28170, 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, 28315, 28319, 28327, 28330, 28338, 28343, 28345, 28347, 28350, 28351, 28352, 28353, 28361, 28363, 28364, 28367, 28370, 28372, 28373, 28374, 28376, 28377, 28379, 28380, 28383, 28387, 28388, 28394, 28396, 28559, 28601, 28602, 28603, 28605, 28606, 28609, 28610, 28611, 28612, 28613, 28616, 28618, 28619, 28620, 28621, 28624, 28625, 28628, 28630, 28633, 28634, 28636, 28637, 28638, 28641, 28642, 28645, 28647, 28650, 28651, 28654, 28655, 28656, 28658, 28659, 28660, 28661, 28662, 28665, 28666, 28667, 28669, 28670, 28671, 28673, 28674, 28677, 28678, 28680, 28681, 28682, 28687, 28688, 28689, 28690, 28697, 28699, 28710, 28711, 28718, 28720, 28722, 28724, 28726, 28727, 28730, 28731, 28732, 28735, 28737, 28739, 28746, 28749, 28750, 28752, 28756, 28757, 28758, 28760, 28761, 28762, 28767, 28770, 28773, 28777, 28778, 28782, 28784, 28790, 28791, 28792, 28793, 28796, 28894, 28971, 28972, 29001, 29002, 29006, 29009, 29010, 29014, 29015, 29016, 29020, 29030, 29031, 29032, 29033, 29036, 29037, 29039, 29040, 29041, 29044, 29045, 29046, 29047, 29051, 29052, 29053, 29054, 29055, 29056, 29058, 29061, 29062, 29063, 29065, 29066, 29067, 29069, 29070, 29071, 29072, 29073, 29074, 29075, 29078, 29079, 29080, 29101, 29102, 29103, 29104, 29105, 29106, 29107, 29108, 29111, 29112, 29113, 29114, 29115, 29116, 29117, 29118, 29122, 29123, 29124, 29125, 29126, 29127, 29128, 29129, 29130, 29132, 29135, 29137, 29138, 29142, 29143, 29145, 29146, 29147, 29148, 29150, 29151, 29152, 29153, 29154, 29160, 29161, 29162, 29164, 29166, 29168, 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, 29501, 29502, 29503, 29504, 29505, 29506, 29512, 29516, 29518, 29520, 29525, 29530, 29532, 29536, 29540, 29541, 29542, 29547, 29550, 29551, 29560, 29561, 29565, 29567, 29570, 29571, 29573, 29583, 29584, 29591, 29592, 29593, 29594, 29596, 29601, 29602, 29603, 29604, 29605, 29606, 29607, 29608, 29609, 29610, 29611, 29612, 29613, 29614, 29615, 29616, 29617, 29620, 29621, 29627, 29635, 29636, 29638, 29639, 29640, 29641, 29642, 29644, 29645, 29646, 29647, 29648, 29649, 29650, 29651, 29652, 29653, 29654, 29661, 29662, 29666, 29669, 29673, 29680, 29681, 29683, 29687, 29688, 29690, 29692, 29695, 29697, 29698, 29702, 29703, 29704, 29706, 29708, 29709, 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, 29804, 29805, 29808, 29819, 29824, 29832, 29839, 29847, 29848, 29850, 29861)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
