| |
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 / 1227059050 * 100 AS score from hr_url url, hr_users
where url_user_id = user_id and url_type=0 and user_zip in (3215, 3216, 3217, 3218, 3220, 3221, 3222, 3223, 3224, 3225, 3226, 3227, 3229, 3230, 3231, 3232, 3233, 3235, 3237, 3238, 3240, 3241, 3243, 3245, 3246, 3247, 3249, 3251, 3252, 3253, 3254, 3255, 3256, 3257, 3258, 3259, 3260, 3262, 3263, 3264, 3266, 3268, 3269, 3272, 3273, 3274, 3276, 3278, 3279, 3282, 3284, 3287, 3289, 3293, 3298, 3299, 3302, 3303, 3307, 3386, 3552, 3561, 3570, 3572, 3574, 3575, 3576, 3578, 3579, 3580, 3581, 3582, 3583, 3584, 3585, 3587, 3588, 3589, 3590, 3592, 3595, 3597, 3598, 3601, 3603, 3605, 3638, 3648, 3678, 3733, 3740, 3741, 3743, 3745, 3746, 3747, 3748, 3749, 3750, 3751, 3752, 3753, 3754, 3755, 3756, 3757, 3765, 3766, 3768, 3769, 3770, 3771, 3773, 3774, 3777, 3779, 3780, 3781, 3782, 3784, 3785, 3809, 3810, 3812, 3813, 3814, 3816, 3817, 3818, 3821, 3822, 3830, 3832, 3835, 3836, 3837, 3838, 3845, 3846, 3847, 3849, 3850, 3851, 3852, 3853, 3855, 3860, 3864, 3866, 3872, 3875, 3882, 3883, 3886, 3887, 3890, 3894, 3896, 3897, 4001, 4002, 4009, 4010, 4013, 4015, 4016, 4020, 4021, 4022, 4024, 4027, 4028, 4029, 4030, 4031, 4033, 4034, 4037, 4038, 4039, 4040, 4041, 4042, 4047, 4048, 4049, 4051, 4053, 4055, 4056, 4057, 4061, 4062, 4068, 4069, 4071, 4075, 4076, 4077, 4081, 4082, 4083, 4084, 4085, 4087, 4088, 4091, 4092, 4093, 4095, 4097, 4098, 4104, 4112, 4116, 4122, 4123, 4124, 4210, 4211, 4212, 4216, 4217, 4219, 4220, 4221, 4222, 4223, 4224, 4225, 4226, 4227, 4228, 4230, 4231, 4234, 4236, 4237, 4238, 4239, 4240, 4241, 4243, 4250, 4252, 4253, 4254, 4255, 4256, 4257, 4258, 4259, 4260, 4261, 4262, 4263, 4265, 4266, 4267, 4268, 4270, 4271, 4273, 4274, 4275, 4276, 4278, 4279, 4280, 4281, 4282, 4283, 4284, 4285, 4286, 4288, 4289, 4290, 4291, 4292, 4294, 4321, 4349, 4352, 4355, 4360, 4364, 4724, 4911, 4936, 4938, 4940, 4947, 4954, 4955, 4956, 4958, 4961, 4964, 4966, 4970, 4982, 4983, 4984, 4992, 5001, 5009, 5030, 5031, 5032, 5033, 5034, 5035, 5036, 5037, 5038, 5039, 5040, 5041, 5042, 5043, 5045, 5046, 5047, 5048, 5049, 5050, 5051, 5052, 5053, 5054, 5055, 5056, 5058, 5059, 5060, 5061, 5062, 5065, 5067, 5068, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5077, 5079, 5080, 5081, 5083, 5084, 5085, 5086, 5088, 5089, 5091, 5124, 5142, 5144, 5149, 5150, 5151, 5153, 5156, 5219, 5233, 5267, 5286, 5401, 5402, 5403, 5404, 5405, 5406, 5407, 5418, 5433, 5439, 5440, 5441, 5442, 5443, 5444, 5445, 5446, 5447, 5448, 5449, 5450, 5451, 5452, 5453, 5454, 5455, 5456, 5457, 5458, 5459, 5460, 5461, 5462, 5463, 5464, 5465, 5466, 5468, 5469, 5470, 5471, 5472, 5473, 5474, 5476, 5477, 5478, 5479, 5481, 5482, 5483, 5485, 5486, 5487, 5488, 5489, 5490, 5491, 5492, 5494, 5495, 5601, 5602, 5603, 5604, 5609, 5620, 5626, 5633, 5640, 5641, 5647, 5648, 5649, 5650, 5651, 5652, 5653, 5654, 5655, 5656, 5657, 5658, 5660, 5661, 5662, 5663, 5664, 5665, 5666, 5667, 5669, 5670, 5671, 5672, 5673, 5674, 5675, 5676, 5677, 5678, 5679, 5680, 5681, 5682, 5701, 5730, 5731, 5732, 5733, 5734, 5735, 5736, 5737, 5738, 5740, 5741, 5742, 5743, 5744, 5745, 5746, 5747, 5748, 5750, 5751, 5753, 5758, 5759, 5760, 5762, 5763, 5765, 5766, 5767, 5769, 5770, 5772, 5773, 5777, 5778, 5801, 5819, 5820, 5821, 5822, 5823, 5824, 5825, 5826, 5827, 5828, 5829, 5830, 5832, 5833, 5836, 5837, 5838, 5839, 5840, 5841, 5842, 5843, 5845, 5846, 5847, 5848, 5849, 5850, 5851, 5852, 5853, 5855, 5857, 5858, 5859, 5860, 5861, 5862, 5863, 5864, 5866, 5867, 5868, 5871, 5872, 5873, 5874, 5875, 5892, 5901, 5902, 5903, 5904, 5905, 5906, 5907, 5928, 5958, 12861, 12883, 12901, 12903, 12910, 12911, 12912, 12918, 12919, 12921, 12924, 12928, 12929, 12932, 12935, 12936, 12941, 12942, 12943, 12944, 12950, 12956, 12958, 12959, 12960, 12961, 12962, 12964, 12972, 12974, 12975, 12978, 12979, 12981, 12985, 12987, 12992, 12993, 12996, 12998)
ORDER BY score desc
LIMIT 0, 10 Line : 418 File : /var/www/vhosts/hotref.com/httpdocs/includes/functions_hotsearch.php |
| |
|