| |
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 / 7 * 10) + user_session_time / 1227046559 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (28006, 28012, 28016, 28017, 28018, 28019, 28020, 28021, 28024, 28032, 28033, 28034, 28038, 28040, 28042, 28043, 28051, 28052, 28053, 28054, 28055, 28056, 28073, 28074, 28076, 28077, 28080, 28086, 28089, 28090, 28092, 28093, 28098, 28101, 28114, 28120, 28134, 28136, 28139, 28150, 28151, 28152, 28160, 28164, 28167, 28168, 28169, 28208, 28210, 28214, 28217, 28247, 28273, 28278, 28601, 28602, 28603, 28611, 28612, 28616, 28619, 28628, 28630, 28633, 28637, 28638, 28641, 28645, 28646, 28647, 28650, 28652, 28653, 28655, 28657, 28658, 28662, 28664, 28666, 28667, 28671, 28680, 28690, 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, 28733, 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, 28771, 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, 28901, 28902, 28903, 28904, 28905, 28906, 28909, 28971, 28972, 29002, 29006, 29014, 29015, 29016, 29031, 29036, 29037, 29054, 29055, 29063, 29065, 29066, 29070, 29071, 29072, 29073, 29075, 29105, 29106, 29108, 29122, 29126, 29127, 29129, 29132, 29138, 29145, 29166, 29170, 29171, 29176, 29177, 29178, 29180, 29210, 29212, 29228, 29230, 29235, 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, 29724, 29726, 29729, 29730, 29731, 29732, 29733, 29734, 29742, 29743, 29744, 29745, 29801, 29802, 29805, 29816, 29819, 29821, 29822, 29824, 29828, 29829, 29832, 29834, 29835, 29838, 29840, 29841, 29844, 29845, 29847, 29848, 29850, 29851, 29860, 29899, 30011, 30019, 30024, 30028, 30040, 30041, 30043, 30045, 30148, 30501, 30502, 30503, 30504, 30505, 30506, 30507, 30510, 30511, 30512, 30514, 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, 30559, 30560, 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, 30664, 30665, 30666, 30667, 30668, 30669, 30671, 30673, 30677, 30678, 30680, 30683, 30802, 30806, 30807, 30808, 30809, 30813, 30814, 30817, 30819, 30821, 30824, 30828, 30901, 30904, 30905, 30907, 30909, 30917, 37616, 37641, 37650, 37657, 37692, 37713, 37722, 37725, 37727, 37738, 37743, 37744, 37753, 37809, 37818, 37821, 37822, 37843, 37862, 37863, 37864, 37865, 37868, 37876, 37878, 37882, 37886, 37890)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
