| |
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 / 1227039648 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1020 and user_zip in (73002, 73004, 73005, 73006, 73010, 73011, 73012, 73017, 73018, 73019, 73023, 73026, 73029, 73030, 73031, 73032, 73051, 73052, 73055, 73057, 73065, 73067, 73068, 73069, 73070, 73071, 73072, 73074, 73075, 73079, 73080, 73082, 73086, 73089, 73092, 73093, 73095, 73098, 73160, 73165, 73170, 73367, 73401, 73402, 73403, 73425, 73430, 73432, 73433, 73434, 73435, 73436, 73437, 73438, 73439, 73440, 73441, 73442, 73443, 73444, 73445, 73446, 73447, 73448, 73449, 73450, 73453, 73455, 73456, 73458, 73459, 73460, 73461, 73463, 73476, 73481, 73487, 73488, 73491, 73501, 73502, 73503, 73505, 73506, 73507, 73520, 73527, 73528, 73529, 73530, 73531, 73533, 73534, 73536, 73538, 73540, 73541, 73542, 73543, 73546, 73548, 73551, 73552, 73553, 73555, 73557, 73558, 73561, 73562, 73565, 73567, 73568, 73569, 73572, 73573, 73575, 74520, 74525, 74530, 74531, 74533, 74534, 74535, 74538, 74542, 74553, 74555, 74556, 74569, 74570, 74572, 74576, 74701, 74702, 74720, 74721, 74723, 74726, 74727, 74729, 74730, 74731, 74733, 74741, 74747, 74748, 74753, 74759, 74801, 74807, 74818, 74820, 74821, 74825, 74826, 74827, 74830, 74831, 74836, 74842, 74843, 74844, 74848, 74849, 74852, 74854, 74856, 74857, 74865, 74866, 74867, 74871, 74872, 74873, 74878, 74884, 74894, 75001, 75002, 75006, 75007, 75008, 75009, 75010, 75011, 75013, 75014, 75015, 75016, 75017, 75019, 75020, 75021, 75022, 75023, 75024, 75025, 75026, 75027, 75028, 75029, 75030, 75032, 75034, 75035, 75037, 75038, 75039, 75040, 75041, 75042, 75043, 75044, 75045, 75046, 75047, 75048, 75049, 75050, 75051, 75052, 75053, 75054, 75056, 75057, 75058, 75059, 75060, 75061, 75062, 75063, 75065, 75066, 75067, 75068, 75069, 75070, 75071, 75074, 75075, 75076, 75077, 75078, 75080, 75081, 75082, 75083, 75085, 75086, 75087, 75088, 75089, 75090, 75091, 75092, 75093, 75094, 75097, 75098, 75099, 75104, 75106, 75115, 75116, 75121, 75123, 75126, 75132, 75134, 75135, 75137, 75138, 75141, 75146, 75149, 75150, 75164, 75166, 75172, 75173, 75180, 75181, 75182, 75185, 75187, 75189, 75201, 75202, 75203, 75204, 75205, 75206, 75207, 75208, 75209, 75210, 75211, 75212, 75214, 75215, 75216, 75217, 75218, 75219, 75220, 75221, 75222, 75223, 75224, 75225, 75226, 75227, 75228, 75229, 75230, 75231, 75232, 75233, 75234, 75235, 75236, 75237, 75238, 75239, 75240, 75241, 75242, 75243, 75244, 75245, 75246, 75247, 75248, 75249, 75250, 75251, 75252, 75253, 75254, 75255, 75258, 75260, 75261, 75262, 75263, 75264, 75265, 75266, 75267, 75270, 75275, 75277, 75283, 75284, 75285, 75286, 75287, 75294, 75295, 75301, 75303, 75310, 75312, 75313, 75315, 75320, 75323, 75326, 75336, 75339, 75342, 75346, 75350, 75353, 75354, 75355, 75356, 75357, 75359, 75360, 75363, 75364, 75367, 75368, 75370, 75371, 75372, 75373, 75374, 75376, 75378, 75379, 75380, 75381, 75382, 75386, 75387, 75388, 75389, 75390, 75391, 75392, 75393, 75394, 75395, 75396, 75397, 75398, 75401, 75402, 75403, 75404, 75407, 75408, 75409, 75413, 75414, 75415, 75418, 75421, 75422, 75423, 75424, 75428, 75429, 75438, 75439, 75442, 75443, 75446, 75447, 75448, 75449, 75452, 75454, 75458, 75459, 75469, 75470, 75475, 75476, 75477, 75479, 75485, 75486, 75488, 75489, 75490, 75491, 75492, 75495, 75496, 75499, 75806, 76001, 76002, 76003, 76004, 76005, 76006, 76007, 76008, 76010, 76011, 76012, 76013, 76014, 76015, 76016, 76017, 76018, 76019, 76020, 76021, 76022, 76023, 76025, 76028, 76034, 76035, 76036, 76039, 76040, 76051, 76052, 76053, 76054, 76060, 76061, 76063, 76066, 76067, 76068, 76071, 76073, 76078, 76082, 76085, 76086, 76087, 76088, 76092, 76094, 76095, 76096, 76097, 76098, 76099, 76101, 76102, 76103, 76104, 76105, 76106, 76107, 76108, 76109, 76110, 76111, 76112, 76113, 76114, 76115, 76116, 76117, 76118, 76119, 76120, 76121, 76122, 76123, 76124, 76126, 76127, 76129, 76130, 76131, 76132, 76133, 76134, 76135, 76136, 76137, 76140, 76147, 76148, 76150, 76153, 76155, 76161, 76162, 76163, 76164, 76177, 76178, 76179, 76180, 76181, 76182, 76185, 76191, 76192, 76193, 76195, 76196, 76197, 76198, 76199, 76201, 76202, 76203, 76204, 76205, 76206, 76207, 76208, 76209, 76210, 76225, 76226, 76227, 76228, 76230, 76233, 76234, 76238, 76239, 76240, 76241, 76244, 76245, 76246, 76247, 76248, 76249, 76250, 76251, 76252, 76253, 76255, 76258, 76259, 76261, 76262, 76263, 76264, 76265, 76266, 76267, 76268, 76270, 76271, 76272, 76273, 76299, 76301, 76302, 76303, 76304, 76305, 76306, 76307, 76308, 76309, 76310, 76311, 76351, 76352, 76354, 76356, 76357, 76360, 76364, 76365, 76366, 76367, 76369, 76370, 76372, 76374, 76377, 76379, 76389, 76420, 76426, 76427, 76431, 76439, 76449, 76450, 76458, 76459, 76460, 76484, 76485, 76486, 76487, 76490)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
