| |
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 / 1227072918 * 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 (37501, 38002, 38004, 38008, 38010, 38011, 38012, 38014, 38015, 38016, 38017, 38018, 38019, 38023, 38026, 38027, 38028, 38029, 38036, 38039, 38041, 38042, 38043, 38044, 38045, 38046, 38048, 38049, 38052, 38053, 38054, 38055, 38057, 38058, 38060, 38061, 38063, 38066, 38067, 38068, 38069, 38071, 38074, 38075, 38076, 38083, 38088, 38101, 38103, 38104, 38105, 38106, 38107, 38108, 38109, 38110, 38111, 38112, 38113, 38114, 38115, 38116, 38117, 38118, 38119, 38120, 38122, 38124, 38125, 38126, 38127, 38128, 38130, 38131, 38132, 38133, 38134, 38135, 38136, 38137, 38138, 38139, 38140, 38141, 38142, 38143, 38145, 38146, 38147, 38148, 38150, 38151, 38152, 38157, 38159, 38160, 38161, 38163, 38165, 38166, 38167, 38168, 38173, 38174, 38175, 38177, 38181, 38182, 38183, 38184, 38186, 38187, 38188, 38190, 38193, 38194, 38195, 38197, 38315, 38339, 38356, 38367, 38375, 38377, 38381, 38392, 38393, 38514, 38597, 38601, 38602, 38603, 38606, 38609, 38610, 38611, 38614, 38617, 38618, 38619, 38620, 38621, 38622, 38623, 38625, 38626, 38627, 38628, 38629, 38630, 38631, 38632, 38633, 38634, 38635, 38637, 38638, 38639, 38641, 38642, 38643, 38644, 38645, 38646, 38647, 38649, 38650, 38651, 38652, 38654, 38655, 38658, 38659, 38661, 38663, 38664, 38665, 38666, 38668, 38669, 38670, 38671, 38672, 38673, 38674, 38675, 38676, 38677, 38679, 38680, 38683, 38685, 38686, 38695, 38701, 38702, 38703, 38704, 38720, 38722, 38723, 38725, 38726, 38730, 38732, 38733, 38736, 38737, 38738, 38739, 38740, 38746, 38748, 38749, 38751, 38753, 38754, 38756, 38758, 38759, 38760, 38761, 38762, 38764, 38767, 38768, 38769, 38771, 38772, 38773, 38774, 38776, 38778, 38780, 38781, 38782, 38801, 38802, 38803, 38804, 38820, 38821, 38824, 38825, 38826, 38828, 38829, 38834, 38835, 38838, 38839, 38841, 38843, 38846, 38847, 38848, 38849, 38850, 38851, 38854, 38855, 38856, 38857, 38858, 38859, 38860, 38862, 38863, 38864, 38865, 38866, 38868, 38869, 38870, 38871, 38874, 38875, 38876, 38877, 38878, 38879, 38880, 38901, 38902, 38912, 38913, 38914, 38915, 38916, 38917, 38920, 38921, 38922, 38923, 38924, 38925, 38926, 38927, 38928, 38929, 38930, 38935, 38940, 38941, 38943, 38944, 38945, 38946, 38947, 38948, 38949, 38950, 38951, 38952, 38953, 38954, 38955, 38957, 38958, 38959, 38960, 38961, 38962, 38963, 38964, 38965, 38966, 38967, 39038, 39061, 39063, 39067, 39079, 39090, 39095, 39097, 39107, 39108, 39115, 39146, 39160, 39166, 39169, 39176, 39192, 39339, 39357, 39730, 39735, 39736, 39737, 39741, 39744, 39745, 39746, 39747, 39750, 39751, 39752, 39753, 39754, 39755, 39756, 39758, 39759, 39760, 39762, 39767, 39769, 39771, 39772, 39773, 39776, 71630, 71639, 71643, 71653, 71654, 71662, 71666, 71670, 71674, 71677, 72003, 72017, 72021, 72026, 72029, 72036, 72038, 72040, 72041, 72042, 72048, 72055, 72059, 72064, 72066, 72069, 72071, 72073, 72074, 72101, 72108, 72123, 72133, 72134, 72140, 72160, 72166, 72170, 72189, 72301, 72303, 72311, 72312, 72313, 72314, 72316, 72319, 72320, 72322, 72324, 72325, 72326, 72327, 72328, 72329, 72330, 72331, 72332, 72333, 72335, 72336, 72338, 72339, 72340, 72341, 72342, 72345, 72346, 72347, 72348, 72350, 72351, 72352, 72353, 72354, 72355, 72359, 72360, 72364, 72365, 72366, 72367, 72368, 72369, 72370, 72372, 72373, 72374, 72376, 72377, 72379, 72381, 72383, 72384, 72385, 72386, 72387, 72389, 72390, 72391, 72392, 72394, 72395, 72396, 72397, 72429, 72432, 72472)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
