| |
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 + user_session_time / 1227052124 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and url_cat1=1070 and user_zip in (75001, 75002, 75006, 75007, 75008, 75010, 75011, 75013, 75014, 75015, 75016, 75017, 75019, 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, 75059, 75060, 75061, 75062, 75063, 75065, 75066, 75067, 75068, 75069, 75070, 75071, 75074, 75075, 75077, 75078, 75080, 75081, 75082, 75083, 75085, 75086, 75087, 75088, 75089, 75093, 75094, 75098, 75099, 75101, 75102, 75103, 75104, 75105, 75106, 75109, 75110, 75114, 75115, 75116, 75117, 75118, 75119, 75120, 75121, 75123, 75124, 75125, 75126, 75127, 75132, 75134, 75135, 75137, 75138, 75140, 75141, 75142, 75143, 75144, 75146, 75147, 75148, 75149, 75150, 75151, 75152, 75153, 75154, 75155, 75156, 75157, 75158, 75159, 75160, 75161, 75163, 75164, 75165, 75166, 75167, 75168, 75169, 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, 75407, 75442, 75453, 75472, 75474, 75751, 75752, 75754, 75756, 75758, 75759, 75763, 75770, 75778, 75779, 75782, 75790, 75801, 75802, 75803, 75806, 75831, 75832, 75833, 75838, 75839, 75840, 75844, 75846, 75848, 75850, 75853, 75855, 75859, 75860, 75861, 75880, 75882, 75884, 75886, 76001, 76002, 76003, 76004, 76005, 76006, 76007, 76008, 76009, 76010, 76011, 76012, 76013, 76014, 76015, 76016, 76017, 76018, 76019, 76020, 76021, 76022, 76023, 76025, 76028, 76031, 76033, 76034, 76035, 76036, 76039, 76040, 76041, 76043, 76044, 76048, 76049, 76050, 76051, 76052, 76053, 76054, 76055, 76058, 76059, 76060, 76061, 76063, 76064, 76065, 76066, 76067, 76068, 76070, 76071, 76073, 76077, 76078, 76082, 76084, 76085, 76086, 76087, 76088, 76092, 76093, 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, 76226, 76227, 76234, 76244, 76247, 76248, 76249, 76259, 76262, 76299, 76345, 76401, 76402, 76433, 76436, 76439, 76442, 76444, 76445, 76446, 76452, 76453, 76454, 76455, 76457, 76461, 76462, 76463, 76465, 76467, 76468, 76472, 76474, 76475, 76476, 76484, 76485, 76486, 76487, 76490, 76501, 76502, 76503, 76504, 76505, 76508, 76511, 76513, 76518, 76519, 76520, 76522, 76523, 76524, 76525, 76526, 76527, 76528, 76530, 76531, 76533, 76534, 76537, 76538, 76539, 76540, 76541, 76542, 76543, 76544, 76545, 76546, 76547, 76548, 76549, 76550, 76552, 76554, 76555, 76556, 76557, 76558, 76559, 76561, 76564, 76565, 76566, 76567, 76569, 76570, 76571, 76573, 76574, 76576, 76577, 76578, 76579, 76596, 76597, 76598, 76599, 76607, 76618, 76621, 76622, 76623, 76624, 76626, 76627, 76628, 76629, 76630, 76631, 76632, 76633, 76634, 76635, 76636, 76637, 76638, 76639, 76640, 76641, 76642, 76643, 76644, 76645, 76648, 76649, 76650, 76651, 76652, 76653, 76654, 76655, 76656, 76657, 76660, 76661, 76664, 76665, 76666, 76667, 76670, 76671, 76673, 76675, 76676, 76677, 76678, 76679, 76680, 76681, 76682, 76683, 76684, 76685, 76686, 76687, 76689, 76690, 76691, 76692, 76693, 76701, 76702, 76703, 76704, 76705, 76706, 76707, 76708, 76710, 76711, 76712, 76714, 76715, 76716, 76795, 76797, 76798, 76799, 76844, 76853, 76864, 76870, 76880, 77801, 77802, 77803, 77805, 77806, 77807, 77808, 77836, 77837, 77838, 77840, 77842, 77843, 77844, 77850, 77852, 77855, 77856, 77857, 77859, 77861, 77862, 77864, 77865, 77867, 77869, 77870, 77871, 77872, 77881, 77882, 78571, 78605, 78608, 78626, 78627, 78628, 78630, 78634, 78642, 78646, 78673, 78674, 78680, 78682, 78683)
ORDER BY score desc
LIMIT 0, 10
Line : 418
File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|
