Расценки на строительные и ремонтные работы Украина

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:users_categories"
from cache

begin:system.db.CDbCommand.query(SELECT * FROM `users_categories` `t`)

end:system.db.CDbCommand.query(SELECT * FROM `users_categories` `t`)

Serving "Yii.CUrlManager.rules" from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:geo_countries"
from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:geo_cities"
from cache

Serving "yii:dbquerymysql:host=localhost;dbname=omastere_db:omastere:SELECT
`t`.`country_id` AS `t0_c0`, `t`.`country_name` AS `t0_c1`,
`t`.`country_geo_lat` AS `t0_c2`, `t`.`country_geo_lng` AS `t0_c3`,
`t`.`city_id` AS `t0_c4`, `t`.`capital_id` AS `t0_c5`, `t`.`country_code`
AS `t0_c6`, `t`.`country_domain` AS `t0_c7`, `t`.`country_language` AS
`t0_c8`, `t`.`country_new_domain` AS `t0_c9`, `t`.`country_currency` AS
`t0_c10`, `t`.`country_phone_mask` AS `t0_c11`, `t`.`country_main_article`
AS `t0_c12`, `t`.`country_tenders_article` AS `t0_c13`,
`t`.`country_users_subtext` AS `t0_c14`, `t`.`country_price_article` AS
`t0_c15`, `t`.`country_price_subtext` AS `t0_c16`,
`t`.`country_payments_config` AS `t0_c17`, `t`.`country_jivosite_code` AS
`t0_c18`, `capital`.`city_id` AS `t1_c0`, `capital`.`region_id` AS `t1_c1`,
`capital`.`city_name` AS `t1_c2`, `capital`.`city_url` AS `t1_c3`,
`capital`.`city_geo_lat` AS `t1_c4`, `capital`.`city_geo_lng` AS `t1_c5`,
`capital`.`city_type` AS `t1_c6`, `capital`.`city_sort` AS `t1_c7`,
`capital`.`city_ads_priority` AS `t1_c8` FROM `geo_countries` `t`  LEFT
OUTER JOIN `geo_cities` `capital` ON (`t`.`capital_id`=`capital`.`city_id`)
:a:0:{}" from cache

Serving "yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:logs"
from cache

begin:system.db.CDbCommand.execute(INSERT INTO `logs` (`url`, `code`,
`referer`, `ip`, `agent`, `date`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4,
:yp5))

end:system.db.CDbCommand.execute(INSERT INTO `logs` (`url`, `code`,
`referer`, `ip`, `agent`, `date`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4,
:yp5))

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_categories"
from cache

begin:system.db.CDbCommand.query(SELECT * FROM `services_categories` `t`
WHERE visibility = 1 ORDER BY category_sort, category_name, category_id)

end:system.db.CDbCommand.query(SELECT * FROM `services_categories` `t`
WHERE visibility = 1 ORDER BY category_sort, category_name, category_id)

begin:system.db.CDbCommand.query(SELECT t.service_id,
MIN(service_price_offer) as min, MAX(service_price_offer) as max,
AVG(service_price_offer) as avg, COUNT(service_price_offer) as count
FROM `services_prices` `t`
LEFT JOIN `users` ON users.user_id = t.user_id
LEFT JOIN `services` ON services.service_id = t.service_id
LEFT JOIN `geo_cities` ON geo_cities.city_id = users.city_id
LEFT JOIN `geo_regions` ON geo_regions.region_id = geo_cities.region_id
WHERE (services.user_id IS NULL) AND (geo_regions.country_id = :country_id)
GROUP BY `t`.`service_id`)

end:system.db.CDbCommand.query(SELECT t.service_id,
MIN(service_price_offer) as min, MAX(service_price_offer) as max,
AVG(service_price_offer) as avg, COUNT(service_price_offer) as count
FROM `services_prices` `t`
LEFT JOIN `users` ON users.user_id = t.user_id
LEFT JOIN `services` ON services.service_id = t.service_id
LEFT JOIN `geo_cities` ON geo_cities.city_id = users.city_id
LEFT JOIN `geo_regions` ON geo_regions.region_id = geo_cities.region_id
WHERE (services.user_id IS NULL) AND (geo_regions.country_id = :country_id)
GROUP BY `t`.`service_id`)

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services"
from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:services_gradations"
from cache

begin:system.db.CDbCommand.query(SELECT `t`.`service_id` AS `t0_c0`,
`t`.`service_name` AS `t0_c1`, `t`.`service_url` AS `t0_c2`,
`t`.`service_gradation_id` AS `t0_c3`, `t`.`user_id` AS `t0_c4`,
`t`.`service_priority` AS `t0_c5`, `t`.`service_date` AS `t0_c6`,
`t`.`service_banner` AS `t0_c7`, `serviceGradation`.`service_gradation_id`
AS `t1_c0`, `serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services` `t`  STRAIGHT_JOIN `services_gradations` `serviceGradation` ON
(`t`.`service_gradation_id`=`serviceGradation`.`service_gradation_id`) 
WHERE ((t.service_id IN (:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6,
:ycp7, :ycp8, :ycp9, :ycp10, :ycp11, :ycp12, :ycp13, :ycp14, :ycp15,
:ycp16, :ycp17, :ycp18, :ycp19, :ycp20, :ycp21, :ycp22, :ycp23, :ycp24,
:ycp25, :ycp26, :ycp27, :ycp28, :ycp29, :ycp30, :ycp31, :ycp32, :ycp33,
:ycp34, :ycp35, :ycp36, :ycp37, :ycp38, :ycp39, :ycp40, :ycp41, :ycp42,
:ycp43, :ycp44, :ycp45, :ycp46, :ycp47, :ycp48, :ycp49, :ycp50, :ycp51,
:ycp52, :ycp53, :ycp54, :ycp55, :ycp56, :ycp57, :ycp58, :ycp59, :ycp60,
:ycp61, :ycp62, :ycp63, :ycp64, :ycp65, :ycp66, :ycp67, :ycp68, :ycp69,
:ycp70, :ycp71, :ycp72, :ycp73, :ycp74, :ycp75, :ycp76, :ycp77, :ycp78,
:ycp79, :ycp80, :ycp81, :ycp82, :ycp83, :ycp84, :ycp85, :ycp86, :ycp87,
:ycp88, :ycp89, :ycp90, :ycp91, :ycp92, :ycp93, :ycp94, :ycp95, :ycp96,
:ycp97, :ycp98, :ycp99, :ycp100, :ycp101, :ycp102, :ycp103, :ycp104,
:ycp105, :ycp106, :ycp107, :ycp108, :ycp109, :ycp110, :ycp111, :ycp112,
:ycp113, :ycp114, :ycp115, :ycp116, :ycp117, :ycp118, :ycp119, :ycp120,
:ycp121, :ycp122, :ycp123, :ycp124, :ycp125, :ycp126, :ycp127, :ycp128,
:ycp129, :ycp130, :ycp131, :ycp132, :ycp133, :ycp134, :ycp135, :ycp136,
:ycp137, :ycp138, :ycp139, :ycp140, :ycp141, :ycp142, :ycp143, :ycp144,
:ycp145, :ycp146, :ycp147, :ycp148, :ycp149, :ycp150, :ycp151, :ycp152,
:ycp153, :ycp154, :ycp155, :ycp156, :ycp157, :ycp158, :ycp159, :ycp160,
:ycp161, :ycp162, :ycp163, :ycp164, :ycp165, :ycp166, :ycp167, :ycp168,
:ycp169, :ycp170, :ycp171, :ycp172, :ycp173, :ycp174, :ycp175, :ycp176,
:ycp177, :ycp178, :ycp179, :ycp180, :ycp181, :ycp182, :ycp183, :ycp184,
:ycp185, :ycp186, :ycp187, :ycp188, :ycp189, :ycp190, :ycp191, :ycp192,
:ycp193, :ycp194, :ycp195, :ycp196, :ycp197, :ycp198, :ycp199, :ycp200,
:ycp201, :ycp202, :ycp203, :ycp204, :ycp205, :ycp206, :ycp207, :ycp208,
:ycp209, :ycp210, :ycp211, :ycp212, :ycp213, :ycp214, :ycp215, :ycp216,
:ycp217, :ycp218, :ycp219, :ycp220, :ycp221, :ycp222, :ycp223, :ycp224,
:ycp225, :ycp226, :ycp227, :ycp228, :ycp229, :ycp230, :ycp231, :ycp232,
:ycp233, :ycp234, :ycp235, :ycp236, :ycp237, :ycp238, :ycp239, :ycp240,
:ycp241, :ycp242, :ycp243, :ycp244, :ycp245, :ycp246, :ycp247, :ycp248,
:ycp249, :ycp250, :ycp251, :ycp252, :ycp253, :ycp254, :ycp255, :ycp256,
:ycp257, :ycp258, :ycp259, :ycp260, :ycp261, :ycp262, :ycp263, :ycp264,
:ycp265, :ycp266, :ycp267, :ycp268, :ycp269, :ycp270, :ycp271, :ycp272,
:ycp273, :ycp274, :ycp275, :ycp276, :ycp277, :ycp278, :ycp279, :ycp280,
:ycp281, :ycp282, :ycp283, :ycp284, :ycp285, :ycp286, :ycp287, :ycp288,
:ycp289, :ycp290, :ycp291, :ycp292, :ycp293, :ycp294, :ycp295, :ycp296,
:ycp297, :ycp298, :ycp299, :ycp300, :ycp301, :ycp302, :ycp303, :ycp304,
:ycp305, :ycp306, :ycp307, :ycp308, :ycp309, :ycp310, :ycp311, :ycp312,
:ycp313, :ycp314, :ycp315, :ycp316, :ycp317, :ycp318, :ycp319, :ycp320,
:ycp321, :ycp322, :ycp323, :ycp324, :ycp325, :ycp326, :ycp327, :ycp328,
:ycp329, :ycp330, :ycp331, :ycp332, :ycp333, :ycp334, :ycp335, :ycp336,
:ycp337, :ycp338, :ycp339, :ycp340, :ycp341, :ycp342, :ycp343, :ycp344,
:ycp345, :ycp346, :ycp347, :ycp348, :ycp349, :ycp350, :ycp351, :ycp352,
:ycp353, :ycp354, :ycp355, :ycp356, :ycp357, :ycp358, :ycp359, :ycp360,
:ycp361, :ycp362, :ycp363, :ycp364, :ycp365, :ycp366, :ycp367, :ycp368,
:ycp369, :ycp370, :ycp371, :ycp372, :ycp373, :ycp374, :ycp375, :ycp376,
:ycp377, :ycp378, :ycp379, :ycp380, :ycp381, :ycp382, :ycp383, :ycp384,
:ycp385, :ycp386, :ycp387, :ycp388, :ycp389, :ycp390, :ycp391, :ycp392,
:ycp393, :ycp394, :ycp395, :ycp396, :ycp397, :ycp398, :ycp399, :ycp400,
:ycp401, :ycp402, :ycp403, :ycp404, :ycp405, :ycp406, :ycp407, :ycp408,
:ycp409, :ycp410, :ycp411, :ycp412, :ycp413, :ycp414, :ycp415, :ycp416,
:ycp417, :ycp418, :ycp419, :ycp420, :ycp421, :ycp422, :ycp423, :ycp424,
:ycp425, :ycp426, :ycp427, :ycp428, :ycp429, :ycp430, :ycp431, :ycp432,
:ycp433, :ycp434, :ycp435, :ycp436, :ycp437, :ycp438, :ycp439, :ycp440,
:ycp441, :ycp442, :ycp443, :ycp444, :ycp445, :ycp446, :ycp447, :ycp448,
:ycp449, :ycp450, :ycp451, :ycp452, :ycp453, :ycp454, :ycp455, :ycp456,
:ycp457, :ycp458, :ycp459, :ycp460, :ycp461, :ycp462, :ycp463, :ycp464,
:ycp465, :ycp466, :ycp467, :ycp468, :ycp469, :ycp470, :ycp471, :ycp472,
:ycp473, :ycp474, :ycp475, :ycp476, :ycp477, :ycp478, :ycp479, :ycp480,
:ycp481, :ycp482, :ycp483, :ycp484, :ycp485, :ycp486, :ycp487, :ycp488,
:ycp489, :ycp490, :ycp491, :ycp492, :ycp493, :ycp494, :ycp495, :ycp496,
:ycp497, :ycp498, :ycp499, :ycp500, :ycp501, :ycp502, :ycp503, :ycp504,
:ycp505, :ycp506, :ycp507, :ycp508, :ycp509, :ycp510, :ycp511, :ycp512,
:ycp513, :ycp514, :ycp515, :ycp516, :ycp517, :ycp518, :ycp519, :ycp520,
:ycp521, :ycp522, :ycp523, :ycp524, :ycp525, :ycp526, :ycp527, :ycp528,
:ycp529, :ycp530, :ycp531, :ycp532, :ycp533, :ycp534, :ycp535, :ycp536,
:ycp537, :ycp538, :ycp539, :ycp540, :ycp541, :ycp542, :ycp543, :ycp544,
:ycp545, :ycp546, :ycp547, :ycp548, :ycp549, :ycp550, :ycp551, :ycp552,
:ycp553, :ycp554, :ycp555, :ycp556, :ycp557, :ycp558, :ycp559, :ycp560,
:ycp561, :ycp562, :ycp563, :ycp564, :ycp565, :ycp566, :ycp567, :ycp568,
:ycp569, :ycp570, :ycp571, :ycp572, :ycp573, :ycp574, :ycp575, :ycp576,
:ycp577, :ycp578, :ycp579, :ycp580, :ycp581, :ycp582, :ycp583, :ycp584,
:ycp585, :ycp586, :ycp587, :ycp588, :ycp589, :ycp590, :ycp591, :ycp592,
:ycp593, :ycp594, :ycp595, :ycp596, :ycp597, :ycp598, :ycp599, :ycp600,
:ycp601, :ycp602, :ycp603, :ycp604, :ycp605, :ycp606, :ycp607, :ycp608,
:ycp609, :ycp610, :ycp611, :ycp612, :ycp613, :ycp614, :ycp615, :ycp616,
:ycp617, :ycp618, :ycp619, :ycp620, :ycp621, :ycp622, :ycp623, :ycp624,
:ycp625, :ycp626, :ycp627, :ycp628, :ycp629, :ycp630, :ycp631, :ycp632,
:ycp633, :ycp634, :ycp635, :ycp636, :ycp637, :ycp638, :ycp639, :ycp640,
:ycp641, :ycp642, :ycp643, :ycp644, :ycp645, :ycp646, :ycp647, :ycp648,
:ycp649, :ycp650, :ycp651, :ycp652, :ycp653, :ycp654, :ycp655, :ycp656,
:ycp657, :ycp658, :ycp659, :ycp660, :ycp661, :ycp662, :ycp663, :ycp664,
:ycp665, :ycp666, :ycp667, :ycp668, :ycp669, :ycp670, :ycp671, :ycp672,
:ycp673, :ycp674, :ycp675, :ycp676, :ycp677, :ycp678, :ycp679, :ycp680,
:ycp681, :ycp682, :ycp683, :ycp684, :ycp685, :ycp686, :ycp687, :ycp688,
:ycp689, :ycp690, :ycp691, :ycp692, :ycp693, :ycp694, :ycp695, :ycp696,
:ycp697, :ycp698, :ycp699, :ycp700, :ycp701, :ycp702, :ycp703, :ycp704,
:ycp705, :ycp706, :ycp707, :ycp708, :ycp709, :ycp710, :ycp711, :ycp712,
:ycp713, :ycp714, :ycp715, :ycp716, :ycp717, :ycp718, :ycp719, :ycp720,
:ycp721, :ycp722, :ycp723, :ycp724, :ycp725, :ycp726, :ycp727, :ycp728,
:ycp729, :ycp730, :ycp731, :ycp732, :ycp733, :ycp734, :ycp735, :ycp736,
:ycp737, :ycp738, :ycp739, :ycp740, :ycp741, :ycp742, :ycp743, :ycp744,
:ycp745, :ycp746, :ycp747, :ycp748, :ycp749, :ycp750, :ycp751, :ycp752,
:ycp753, :ycp754, :ycp755, :ycp756, :ycp757, :ycp758, :ycp759, :ycp760,
:ycp761, :ycp762, :ycp763, :ycp764, :ycp765, :ycp766, :ycp767, :ycp768,
:ycp769, :ycp770, :ycp771, :ycp772, :ycp773, :ycp774, :ycp775, :ycp776,
:ycp777, :ycp778, :ycp779, :ycp780, :ycp781, :ycp782, :ycp783, :ycp784,
:ycp785, :ycp786, :ycp787, :ycp788, :ycp789, :ycp790, :ycp791, :ycp792,
:ycp793, :ycp794, :ycp795, :ycp796, :ycp797, :ycp798, :ycp799, :ycp800,
:ycp801, :ycp802, :ycp803, :ycp804, :ycp805, :ycp806, :ycp807, :ycp808,
:ycp809, :ycp810, :ycp811, :ycp812, :ycp813, :ycp814, :ycp815, :ycp816,
:ycp817, :ycp818, :ycp819, :ycp820, :ycp821, :ycp822, :ycp823, :ycp824,
:ycp825, :ycp826, :ycp827, :ycp828, :ycp829, :ycp830, :ycp831, :ycp832,
:ycp833, :ycp834, :ycp835, :ycp836, :ycp837, :ycp838, :ycp839, :ycp840,
:ycp841, :ycp842, :ycp843, :ycp844, :ycp845, :ycp846, :ycp847, :ycp848,
:ycp849, :ycp850, :ycp851, :ycp852, :ycp853, :ycp854, :ycp855, :ycp856,
:ycp857, :ycp858, :ycp859, :ycp860, :ycp861, :ycp862, :ycp863, :ycp864,
:ycp865, :ycp866, :ycp867, :ycp868, :ycp869, :ycp870, :ycp871, :ycp872,
:ycp873, :ycp874, :ycp875, :ycp876, :ycp877, :ycp878, :ycp879, :ycp880,
:ycp881, :ycp882, :ycp883, :ycp884, :ycp885, :ycp886, :ycp887, :ycp888,
:ycp889, :ycp890, :ycp891, :ycp892, :ycp893, :ycp894, :ycp895, :ycp896,
:ycp897, :ycp898, :ycp899, :ycp900, :ycp901, :ycp902, :ycp903, :ycp904,
:ycp905, :ycp906, :ycp907, :ycp908, :ycp909, :ycp910, :ycp911, :ycp912,
:ycp913, :ycp914, :ycp915, :ycp916, :ycp917, :ycp918, :ycp919, :ycp920,
:ycp921, :ycp922, :ycp923, :ycp924, :ycp925, :ycp926, :ycp927, :ycp928,
:ycp929, :ycp930, :ycp931, :ycp932, :ycp933, :ycp934, :ycp935, :ycp936,
:ycp937, :ycp938, :ycp939, :ycp940, :ycp941, :ycp942, :ycp943, :ycp944,
:ycp945, :ycp946, :ycp947, :ycp948, :ycp949, :ycp950, :ycp951, :ycp952,
:ycp953, :ycp954, :ycp955, :ycp956, :ycp957, :ycp958, :ycp959, :ycp960,
:ycp961, :ycp962, :ycp963, :ycp964, :ycp965, :ycp966, :ycp967, :ycp968,
:ycp969, :ycp970, :ycp971, :ycp972, :ycp973, :ycp974, :ycp975, :ycp976,
:ycp977, :ycp978, :ycp979, :ycp980, :ycp981, :ycp982, :ycp983, :ycp984,
:ycp985, :ycp986, :ycp987, :ycp988, :ycp989, :ycp990, :ycp991, :ycp992,
:ycp993, :ycp994, :ycp995, :ycp996, :ycp997, :ycp998, :ycp999, :ycp1000,
:ycp1001, :ycp1002, :ycp1003, :ycp1004, :ycp1005, :ycp1006, :ycp1007,
:ycp1008, :ycp1009, :ycp1010, :ycp1011, :ycp1012, :ycp1013, :ycp1014,
:ycp1015, :ycp1016, :ycp1017, :ycp1018, :ycp1019, :ycp1020, :ycp1021,
:ycp1022, :ycp1023, :ycp1024, :ycp1025, :ycp1026, :ycp1027, :ycp1028,
:ycp1029, :ycp1030, :ycp1031, :ycp1032, :ycp1033, :ycp1034, :ycp1035,
:ycp1036, :ycp1037, :ycp1038, :ycp1039, :ycp1040, :ycp1041, :ycp1042,
:ycp1043, :ycp1044, :ycp1045, :ycp1046, :ycp1047, :ycp1048, :ycp1049,
:ycp1050, :ycp1051, :ycp1052, :ycp1053, :ycp1054, :ycp1055, :ycp1056,
:ycp1057, :ycp1058, :ycp1059, :ycp1060, :ycp1061, :ycp1062, :ycp1063,
:ycp1064, :ycp1065, :ycp1066, :ycp1067, :ycp1068, :ycp1069, :ycp1070,
:ycp1071, :ycp1072, :ycp1073, :ycp1074, :ycp1075, :ycp1076, :ycp1077,
:ycp1078, :ycp1079, :ycp1080, :ycp1081, :ycp1082, :ycp1083, :ycp1084,
:ycp1085, :ycp1086, :ycp1087, :ycp1088, :ycp1089, :ycp1090, :ycp1091,
:ycp1092, :ycp1093, :ycp1094, :ycp1095, :ycp1096, :ycp1097, :ycp1098,
:ycp1099, :ycp1100, :ycp1101, :ycp1102, :ycp1103, :ycp1104, :ycp1105,
:ycp1106, :ycp1107, :ycp1108, :ycp1109, :ycp1110, :ycp1111, :ycp1112,
:ycp1113, :ycp1114, :ycp1115, :ycp1116, :ycp1117, :ycp1118, :ycp1119,
:ycp1120, :ycp1121, :ycp1122, :ycp1123, :ycp1124, :ycp1125, :ycp1126,
:ycp1127, :ycp1128, :ycp1129, :ycp1130, :ycp1131, :ycp1132, :ycp1133,
:ycp1134, :ycp1135, :ycp1136, :ycp1137, :ycp1138, :ycp1139, :ycp1140,
:ycp1141, :ycp1142, :ycp1143, :ycp1144, :ycp1145, :ycp1146, :ycp1147,
:ycp1148, :ycp1149, :ycp1150, :ycp1151, :ycp1152, :ycp1153, :ycp1154,
:ycp1155, :ycp1156, :ycp1157, :ycp1158, :ycp1159, :ycp1160, :ycp1161,
:ycp1162, :ycp1163, :ycp1164, :ycp1165, :ycp1166, :ycp1167, :ycp1168,
:ycp1169, :ycp1170, :ycp1171, :ycp1172, :ycp1173, :ycp1174, :ycp1175,
:ycp1176, :ycp1177, :ycp1178, :ycp1179, :ycp1180, :ycp1181, :ycp1182,
:ycp1183, :ycp1184, :ycp1185, :ycp1186, :ycp1187, :ycp1188, :ycp1189,
:ycp1190, :ycp1191, :ycp1192, :ycp1193, :ycp1194, :ycp1195, :ycp1196,
:ycp1197, :ycp1198, :ycp1199, :ycp1200, :ycp1201, :ycp1202, :ycp1203,
:ycp1204, :ycp1205, :ycp1206, :ycp1207, :ycp1208, :ycp1209, :ycp1210,
:ycp1211, :ycp1212, :ycp1213, :ycp1214, :ycp1215, :ycp1216, :ycp1217,
:ycp1218, :ycp1219, :ycp1220, :ycp1221, :ycp1222, :ycp1223, :ycp1224,
:ycp1225, :ycp1226, :ycp1227, :ycp1228, :ycp1229, :ycp1230, :ycp1231,
:ycp1232, :ycp1233, :ycp1234, :ycp1235, :ycp1236, :ycp1237, :ycp1238,
:ycp1239, :ycp1240, :ycp1241, :ycp1242, :ycp1243, :ycp1244, :ycp1245,
:ycp1246, :ycp1247, :ycp1248, :ycp1249, :ycp1250, :ycp1251, :ycp1252,
:ycp1253, :ycp1254, :ycp1255, :ycp1256, :ycp1257, :ycp1258, :ycp1259,
:ycp1260, :ycp1261, :ycp1262, :ycp1263, :ycp1264, :ycp1265, :ycp1266,
:ycp1267, :ycp1268, :ycp1269, :ycp1270, :ycp1271, :ycp1272, :ycp1273,
:ycp1274, :ycp1275, :ycp1276, :ycp1277, :ycp1278, :ycp1279, :ycp1280,
:ycp1281, :ycp1282, :ycp1283, :ycp1284, :ycp1285, :ycp1286, :ycp1287,
:ycp1288, :ycp1289, :ycp1290, :ycp1291, :ycp1292, :ycp1293, :ycp1294,
:ycp1295, :ycp1296, :ycp1297, :ycp1298, :ycp1299, :ycp1300, :ycp1301,
:ycp1302, :ycp1303, :ycp1304, :ycp1305, :ycp1306, :ycp1307, :ycp1308,
:ycp1309, :ycp1310, :ycp1311, :ycp1312, :ycp1313, :ycp1314, :ycp1315,
:ycp1316, :ycp1317, :ycp1318, :ycp1319, :ycp1320, :ycp1321, :ycp1322,
:ycp1323, :ycp1324, :ycp1325, :ycp1326, :ycp1327, :ycp1328, :ycp1329,
:ycp1330, :ycp1331, :ycp1332, :ycp1333, :ycp1334, :ycp1335, :ycp1336,
:ycp1337, :ycp1338, :ycp1339, :ycp1340, :ycp1341, :ycp1342, :ycp1343,
:ycp1344, :ycp1345, :ycp1346, :ycp1347, :ycp1348, :ycp1349, :ycp1350,
:ycp1351, :ycp1352, :ycp1353, :ycp1354, :ycp1355, :ycp1356, :ycp1357,
:ycp1358, :ycp1359, :ycp1360, :ycp1361, :ycp1362, :ycp1363, :ycp1364,
:ycp1365, :ycp1366, :ycp1367, :ycp1368, :ycp1369, :ycp1370, :ycp1371,
:ycp1372, :ycp1373, :ycp1374, :ycp1375, :ycp1376, :ycp1377, :ycp1378,
:ycp1379, :ycp1380, :ycp1381, :ycp1382, :ycp1383, :ycp1384, :ycp1385,
:ycp1386, :ycp1387, :ycp1388, :ycp1389, :ycp1390, :ycp1391, :ycp1392,
:ycp1393, :ycp1394, :ycp1395, :ycp1396, :ycp1397, :ycp1398, :ycp1399,
:ycp1400, :ycp1401, :ycp1402, :ycp1403, :ycp1404, :ycp1405, :ycp1406,
:ycp1407, :ycp1408, :ycp1409, :ycp1410, :ycp1411, :ycp1412, :ycp1413,
:ycp1414, :ycp1415, :ycp1416, :ycp1417, :ycp1418, :ycp1419, :ycp1420,
:ycp1421, :ycp1422, :ycp1423, :ycp1424, :ycp1425, :ycp1426, :ycp1427,
:ycp1428, :ycp1429, :ycp1430, :ycp1431, :ycp1432, :ycp1433, :ycp1434,
:ycp1435, :ycp1436, :ycp1437, :ycp1438, :ycp1439, :ycp1440, :ycp1441,
:ycp1442, :ycp1443, :ycp1444, :ycp1445, :ycp1446, :ycp1447, :ycp1448,
:ycp1449, :ycp1450, :ycp1451, :ycp1452, :ycp1453, :ycp1454, :ycp1455,
:ycp1456, :ycp1457, :ycp1458, :ycp1459, :ycp1460, :ycp1461, :ycp1462,
:ycp1463, :ycp1464, :ycp1465, :ycp1466, :ycp1467, :ycp1468, :ycp1469,
:ycp1470, :ycp1471, :ycp1472, :ycp1473, :ycp1474, :ycp1475, :ycp1476,
:ycp1477, :ycp1478, :ycp1479, :ycp1480, :ycp1481, :ycp1482, :ycp1483,
:ycp1484, :ycp1485, :ycp1486, :ycp1487, :ycp1488, :ycp1489, :ycp1490,
:ycp1491, :ycp1492, :ycp1493, :ycp1494, :ycp1495, :ycp1496, :ycp1497,
:ycp1498, :ycp1499, :ycp1500, :ycp1501, :ycp1502, :ycp1503, :ycp1504,
:ycp1505, :ycp1506, :ycp1507, :ycp1508, :ycp1509, :ycp1510, :ycp1511,
:ycp1512, :ycp1513, :ycp1514, :ycp1515, :ycp1516, :ycp1517, :ycp1518,
:ycp1519, :ycp1520, :ycp1521, :ycp1522, :ycp1523, :ycp1524, :ycp1525,
:ycp1526, :ycp1527, :ycp1528, :ycp1529, :ycp1530, :ycp1531, :ycp1532,
:ycp1533, :ycp1534, :ycp1535, :ycp1536, :ycp1537, :ycp1538, :ycp1539,
:ycp1540, :ycp1541, :ycp1542, :ycp1543, :ycp1544, :ycp1545, :ycp1546,
:ycp1547, :ycp1548, :ycp1549, :ycp1550, :ycp1551, :ycp1552, :ycp1553,
:ycp1554, :ycp1555, :ycp1556, :ycp1557, :ycp1558, :ycp1559, :ycp1560,
:ycp1561, :ycp1562, :ycp1563, :ycp1564, :ycp1565, :ycp1566, :ycp1567,
:ycp1568, :ycp1569, :ycp1570, :ycp1571, :ycp1572, :ycp1573, :ycp1574,
:ycp1575, :ycp1576, :ycp1577, :ycp1578, :ycp1579, :ycp1580, :ycp1581,
:ycp1582, :ycp1583, :ycp1584, :ycp1585, :ycp1586, :ycp1587, :ycp1588,
:ycp1589, :ycp1590, :ycp1591, :ycp1592, :ycp1593, :ycp1594, :ycp1595,
:ycp1596, :ycp1597, :ycp1598, :ycp1599, :ycp1600, :ycp1601, :ycp1602,
:ycp1603, :ycp1604, :ycp1605, :ycp1606, :ycp1607, :ycp1608, :ycp1609,
:ycp1610, :ycp1611, :ycp1612, :ycp1613, :ycp1614, :ycp1615, :ycp1616,
:ycp1617, :ycp1618, :ycp1619, :ycp1620, :ycp1621, :ycp1622, :ycp1623,
:ycp1624, :ycp1625, :ycp1626, :ycp1627, :ycp1628, :ycp1629, :ycp1630,
:ycp1631, :ycp1632, :ycp1633, :ycp1634, :ycp1635, :ycp1636, :ycp1637,
:ycp1638, :ycp1639, :ycp1640, :ycp1641, :ycp1642, :ycp1643, :ycp1644,
:ycp1645, :ycp1646, :ycp1647, :ycp1648, :ycp1649, :ycp1650, :ycp1651,
:ycp1652, :ycp1653, :ycp1654, :ycp1655, :ycp1656, :ycp1657, :ycp1658,
:ycp1659, :ycp1660, :ycp1661, :ycp1662, :ycp1663, :ycp1664, :ycp1665,
:ycp1666, :ycp1667, :ycp1668, :ycp1669, :ycp1670, :ycp1671, :ycp1672,
:ycp1673, :ycp1674, :ycp1675, :ycp1676, :ycp1677, :ycp1678, :ycp1679,
:ycp1680, :ycp1681, :ycp1682, :ycp1683, :ycp1684, :ycp1685, :ycp1686,
:ycp1687, :ycp1688, :ycp1689, :ycp1690, :ycp1691, :ycp1692, :ycp1693,
:ycp1694, :ycp1695, :ycp1696, :ycp1697, :ycp1698, :ycp1699, :ycp1700,
:ycp1701, :ycp1702, :ycp1703, :ycp1704, :ycp1705, :ycp1706, :ycp1707,
:ycp1708, :ycp1709, :ycp1710, :ycp1711, :ycp1712, :ycp1713, :ycp1714,
:ycp1715, :ycp1716, :ycp1717, :ycp1718, :ycp1719, :ycp1720, :ycp1721,
:ycp1722, :ycp1723, :ycp1724, :ycp1725, :ycp1726, :ycp1727, :ycp1728,
:ycp1729, :ycp1730, :ycp1731, :ycp1732, :ycp1733, :ycp1734, :ycp1735,
:ycp1736, :ycp1737, :ycp1738, :ycp1739, :ycp1740, :ycp1741, :ycp1742,
:ycp1743, :ycp1744, :ycp1745, :ycp1746, :ycp1747, :ycp1748, :ycp1749,
:ycp1750, :ycp1751, :ycp1752, :ycp1753, :ycp1754, :ycp1755, :ycp1756,
:ycp1757, :ycp1758, :ycp1759, :ycp1760, :ycp1761, :ycp1762, :ycp1763,
:ycp1764, :ycp1765, :ycp1766, :ycp1767, :ycp1768, :ycp1769, :ycp1770,
:ycp1771, :ycp1772, :ycp1773, :ycp1774, :ycp1775, :ycp1776, :ycp1777,
:ycp1778, :ycp1779, :ycp1780, :ycp1781, :ycp1782, :ycp1783, :ycp1784,
:ycp1785, :ycp1786, :ycp1787, :ycp1788, :ycp1789, :ycp1790, :ycp1791,
:ycp1792, :ycp1793, :ycp1794, :ycp1795, :ycp1796, :ycp1797, :ycp1798,
:ycp1799, :ycp1800, :ycp1801, :ycp1802, :ycp1803, :ycp1804, :ycp1805,
:ycp1806, :ycp1807, :ycp1808, :ycp1809, :ycp1810, :ycp1811, :ycp1812,
:ycp1813, :ycp1814, :ycp1815, :ycp1816, :ycp1817, :ycp1818, :ycp1819,
:ycp1820, :ycp1821, :ycp1822, :ycp1823, :ycp1824, :ycp1825, :ycp1826,
:ycp1827, :ycp1828, :ycp1829, :ycp1830, :ycp1831, :ycp1832, :ycp1833,
:ycp1834, :ycp1835, :ycp1836, :ycp1837, :ycp1838, :ycp1839, :ycp1840,
:ycp1841, :ycp1842, :ycp1843, :ycp1844, :ycp1845, :ycp1846, :ycp1847,
:ycp1848, :ycp1849, :ycp1850, :ycp1851, :ycp1852, :ycp1853, :ycp1854,
:ycp1855, :ycp1856, :ycp1857, :ycp1858, :ycp1859, :ycp1860, :ycp1861,
:ycp1862, :ycp1863, :ycp1864, :ycp1865, :ycp1866, :ycp1867, :ycp1868,
:ycp1869, :ycp1870, :ycp1871, :ycp1872, :ycp1873, :ycp1874, :ycp1875,
:ycp1876, :ycp1877, :ycp1878, :ycp1879, :ycp1880, :ycp1881, :ycp1882,
:ycp1883, :ycp1884, :ycp1885, :ycp1886, :ycp1887, :ycp1888, :ycp1889,
:ycp1890, :ycp1891, :ycp1892, :ycp1893, :ycp1894, :ycp1895, :ycp1896,
:ycp1897, :ycp1898, :ycp1899, :ycp1900, :ycp1901, :ycp1902, :ycp1903,
:ycp1904, :ycp1905, :ycp1906, :ycp1907, :ycp1908, :ycp1909, :ycp1910,
:ycp1911, :ycp1912, :ycp1913, :ycp1914, :ycp1915, :ycp1916, :ycp1917,
:ycp1918, :ycp1919, :ycp1920, :ycp1921, :ycp1922, :ycp1923, :ycp1924,
:ycp1925, :ycp1926, :ycp1927, :ycp1928, :ycp1929, :ycp1930, :ycp1931,
:ycp1932, :ycp1933, :ycp1934, :ycp1935, :ycp1936, :ycp1937, :ycp1938,
:ycp1939, :ycp1940, :ycp1941, :ycp1942, :ycp1943, :ycp1944, :ycp1945,
:ycp1946, :ycp1947, :ycp1948, :ycp1949, :ycp1950, :ycp1951, :ycp1952,
:ycp1953, :ycp1954, :ycp1955, :ycp1956, :ycp1957, :ycp1958, :ycp1959,
:ycp1960, :ycp1961, :ycp1962, :ycp1963, :ycp1964, :ycp1965, :ycp1966,
:ycp1967, :ycp1968, :ycp1969, :ycp1970, :ycp1971, :ycp1972, :ycp1973,
:ycp1974, :ycp1975, :ycp1976, :ycp1977, :ycp1978, :ycp1979, :ycp1980,
:ycp1981, :ycp1982, :ycp1983, :ycp1984, :ycp1985, :ycp1986, :ycp1987,
:ycp1988, :ycp1989, :ycp1990, :ycp1991, :ycp1992, :ycp1993, :ycp1994,
:ycp1995, :ycp1996, :ycp1997, :ycp1998, :ycp1999, :ycp2000, :ycp2001,
:ycp2002, :ycp2003, :ycp2004, :ycp2005, :ycp2006, :ycp2007, :ycp2008,
:ycp2009, :ycp2010, :ycp2011, :ycp2012, :ycp2013, :ycp2014, :ycp2015,
:ycp2016, :ycp2017, :ycp2018, :ycp2019, :ycp2020, :ycp2021, :ycp2022,
:ycp2023, :ycp2024, :ycp2025, :ycp2026, :ycp2027, :ycp2028, :ycp2029,
:ycp2030, :ycp2031, :ycp2032, :ycp2033, :ycp2034, :ycp2035, :ycp2036,
:ycp2037, :ycp2038, :ycp2039, :ycp2040, :ycp2041, :ycp2042, :ycp2043,
:ycp2044, :ycp2045, :ycp2046, :ycp2047, :ycp2048, :ycp2049, :ycp2050,
:ycp2051, :ycp2052, :ycp2053, :ycp2054, :ycp2055, :ycp2056, :ycp2057,
:ycp2058, :ycp2059, :ycp2060, :ycp2061, :ycp2062, :ycp2063, :ycp2064,
:ycp2065, :ycp2066, :ycp2067, :ycp2068, :ycp2069, :ycp2070, :ycp2071,
:ycp2072, :ycp2073, :ycp2074, :ycp2075, :ycp2076, :ycp2077, :ycp2078,
:ycp2079, :ycp2080, :ycp2081, :ycp2082, :ycp2083, :ycp2084, :ycp2085,
:ycp2086, :ycp2087, :ycp2088, :ycp2089, :ycp2090, :ycp2091, :ycp2092,
:ycp2093, :ycp2094, :ycp2095, :ycp2096, :ycp2097, :ycp2098, :ycp2099,
:ycp2100, :ycp2101, :ycp2102, :ycp2103, :ycp2104, :ycp2105, :ycp2106,
:ycp2107, :ycp2108, :ycp2109, :ycp2110, :ycp2111, :ycp2112, :ycp2113,
:ycp2114, :ycp2115, :ycp2116, :ycp2117, :ycp2118, :ycp2119, :ycp2120,
:ycp2121, :ycp2122, :ycp2123, :ycp2124, :ycp2125, :ycp2126, :ycp2127,
:ycp2128, :ycp2129, :ycp2130, :ycp2131, :ycp2132, :ycp2133, :ycp2134,
:ycp2135, :ycp2136, :ycp2137, :ycp2138, :ycp2139, :ycp2140, :ycp2141,
:ycp2142, :ycp2143, :ycp2144, :ycp2145, :ycp2146, :ycp2147, :ycp2148,
:ycp2149, :ycp2150, :ycp2151, :ycp2152, :ycp2153, :ycp2154, :ycp2155,
:ycp2156, :ycp2157, :ycp2158, :ycp2159, :ycp2160, :ycp2161, :ycp2162,
:ycp2163, :ycp2164, :ycp2165, :ycp2166, :ycp2167, :ycp2168, :ycp2169,
:ycp2170, :ycp2171, :ycp2172, :ycp2173, :ycp2174, :ycp2175, :ycp2176,
:ycp2177, :ycp2178, :ycp2179, :ycp2180, :ycp2181, :ycp2182, :ycp2183,
:ycp2184, :ycp2185, :ycp2186, :ycp2187, :ycp2188, :ycp2189, :ycp2190,
:ycp2191, :ycp2192, :ycp2193, :ycp2194, :ycp2195, :ycp2196, :ycp2197,
:ycp2198, :ycp2199, :ycp2200, :ycp2201, :ycp2202, :ycp2203, :ycp2204,
:ycp2205, :ycp2206, :ycp2207, :ycp2208, :ycp2209, :ycp2210, :ycp2211,
:ycp2212, :ycp2213, :ycp2214, :ycp2215, :ycp2216, :ycp2217, :ycp2218,
:ycp2219, :ycp2220, :ycp2221, :ycp2222, :ycp2223, :ycp2224, :ycp2225,
:ycp2226, :ycp2227, :ycp2228, :ycp2229, :ycp2230, :ycp2231, :ycp2232,
:ycp2233, :ycp2234, :ycp2235, :ycp2236, :ycp2237, :ycp2238, :ycp2239,
:ycp2240, :ycp2241, :ycp2242, :ycp2243, :ycp2244, :ycp2245, :ycp2246,
:ycp2247, :ycp2248, :ycp2249, :ycp2250, :ycp2251, :ycp2252, :ycp2253,
:ycp2254, :ycp2255, :ycp2256, :ycp2257, :ycp2258, :ycp2259, :ycp2260,
:ycp2261, :ycp2262, :ycp2263, :ycp2264, :ycp2265, :ycp2266, :ycp2267,
:ycp2268, :ycp2269, :ycp2270, :ycp2271, :ycp2272, :ycp2273, :ycp2274,
:ycp2275, :ycp2276, :ycp2277, :ycp2278, :ycp2279, :ycp2280, :ycp2281,
:ycp2282, :ycp2283, :ycp2284, :ycp2285, :ycp2286, :ycp2287, :ycp2288,
:ycp2289, :ycp2290, :ycp2291, :ycp2292, :ycp2293, :ycp2294, :ycp2295,
:ycp2296, :ycp2297, :ycp2298, :ycp2299, :ycp2300, :ycp2301, :ycp2302,
:ycp2303, :ycp2304, :ycp2305, :ycp2306, :ycp2307, :ycp2308, :ycp2309,
:ycp2310, :ycp2311, :ycp2312, :ycp2313, :ycp2314, :ycp2315, :ycp2316,
:ycp2317, :ycp2318, :ycp2319, :ycp2320, :ycp2321, :ycp2322, :ycp2323,
:ycp2324, :ycp2325, :ycp2326, :ycp2327, :ycp2328, :ycp2329, :ycp2330,
:ycp2331, :ycp2332, :ycp2333, :ycp2334, :ycp2335, :ycp2336, :ycp2337,
:ycp2338, :ycp2339, :ycp2340, :ycp2341, :ycp2342, :ycp2343, :ycp2344,
:ycp2345, :ycp2346, :ycp2347, :ycp2348, :ycp2349, :ycp2350, :ycp2351,
:ycp2352, :ycp2353, :ycp2354, :ycp2355, :ycp2356, :ycp2357, :ycp2358,
:ycp2359, :ycp2360, :ycp2361, :ycp2362, :ycp2363, :ycp2364, :ycp2365,
:ycp2366, :ycp2367, :ycp2368, :ycp2369, :ycp2370, :ycp2371, :ycp2372,
:ycp2373, :ycp2374, :ycp2375, :ycp2376, :ycp2377, :ycp2378, :ycp2379,
:ycp2380, :ycp2381, :ycp2382, :ycp2383, :ycp2384, :ycp2385, :ycp2386,
:ycp2387, :ycp2388, :ycp2389, :ycp2390, :ycp2391, :ycp2392, :ycp2393,
:ycp2394, :ycp2395, :ycp2396, :ycp2397, :ycp2398, :ycp2399, :ycp2400,
:ycp2401, :ycp2402, :ycp2403, :ycp2404, :ycp2405, :ycp2406, :ycp2407,
:ycp2408, :ycp2409, :ycp2410, :ycp2411, :ycp2412, :ycp2413, :ycp2414,
:ycp2415, :ycp2416, :ycp2417, :ycp2418, :ycp2419, :ycp2420, :ycp2421,
:ycp2422, :ycp2423, :ycp2424, :ycp2425, :ycp2426, :ycp2427, :ycp2428,
:ycp2429, :ycp2430, :ycp2431, :ycp2432, :ycp2433, :ycp2434, :ycp2435,
:ycp2436, :ycp2437, :ycp2438, :ycp2439, :ycp2440, :ycp2441, :ycp2442,
:ycp2443, :ycp2444, :ycp2445, :ycp2446, :ycp2447, :ycp2448, :ycp2449,
:ycp2450, :ycp2451, :ycp2452, :ycp2453, :ycp2454, :ycp2455, :ycp2456,
:ycp2457, :ycp2458, :ycp2459, :ycp2460, :ycp2461, :ycp2462, :ycp2463,
:ycp2464, :ycp2465, :ycp2466, :ycp2467, :ycp2468, :ycp2469, :ycp2470,
:ycp2471, :ycp2472, :ycp2473, :ycp2474, :ycp2475, :ycp2476, :ycp2477,
:ycp2478, :ycp2479, :ycp2480, :ycp2481, :ycp2482, :ycp2483, :ycp2484,
:ycp2485, :ycp2486, :ycp2487, :ycp2488, :ycp2489, :ycp2490, :ycp2491,
:ycp2492, :ycp2493, :ycp2494, :ycp2495, :ycp2496, :ycp2497, :ycp2498,
:ycp2499, :ycp2500, :ycp2501, :ycp2502, :ycp2503, :ycp2504, :ycp2505,
:ycp2506, :ycp2507, :ycp2508, :ycp2509, :ycp2510, :ycp2511, :ycp2512,
:ycp2513, :ycp2514, :ycp2515, :ycp2516, :ycp2517, :ycp2518, :ycp2519,
:ycp2520, :ycp2521, :ycp2522, :ycp2523, :ycp2524, :ycp2525, :ycp2526,
:ycp2527, :ycp2528, :ycp2529, :ycp2530, :ycp2531, :ycp2532, :ycp2533,
:ycp2534, :ycp2535, :ycp2536, :ycp2537, :ycp2538, :ycp2539, :ycp2540,
:ycp2541, :ycp2542, :ycp2543, :ycp2544, :ycp2545, :ycp2546, :ycp2547,
:ycp2548, :ycp2549, :ycp2550, :ycp2551, :ycp2552, :ycp2553, :ycp2554,
:ycp2555, :ycp2556, :ycp2557, :ycp2558, :ycp2559, :ycp2560, :ycp2561,
:ycp2562, :ycp2563, :ycp2564, :ycp2565, :ycp2566, :ycp2567, :ycp2568,
:ycp2569, :ycp2570, :ycp2571, :ycp2572, :ycp2573, :ycp2574, :ycp2575,
:ycp2576, :ycp2577, :ycp2578, :ycp2579, :ycp2580, :ycp2581, :ycp2582,
:ycp2583, :ycp2584, :ycp2585, :ycp2586, :ycp2587, :ycp2588, :ycp2589,
:ycp2590, :ycp2591, :ycp2592, :ycp2593, :ycp2594, :ycp2595, :ycp2596,
:ycp2597, :ycp2598, :ycp2599, :ycp2600, :ycp2601, :ycp2602, :ycp2603,
:ycp2604, :ycp2605, :ycp2606, :ycp2607, :ycp2608, :ycp2609, :ycp2610,
:ycp2611, :ycp2612, :ycp2613, :ycp2614, :ycp2615, :ycp2616, :ycp2617,
:ycp2618, :ycp2619, :ycp2620, :ycp2621, :ycp2622, :ycp2623, :ycp2624,
:ycp2625, :ycp2626, :ycp2627, :ycp2628, :ycp2629, :ycp2630, :ycp2631,
:ycp2632, :ycp2633, :ycp2634, :ycp2635, :ycp2636, :ycp2637, :ycp2638,
:ycp2639, :ycp2640, :ycp2641, :ycp2642, :ycp2643, :ycp2644, :ycp2645,
:ycp2646, :ycp2647, :ycp2648, :ycp2649, :ycp2650, :ycp2651, :ycp2652,
:ycp2653, :ycp2654, :ycp2655, :ycp2656, :ycp2657, :ycp2658, :ycp2659,
:ycp2660, :ycp2661, :ycp2662, :ycp2663, :ycp2664, :ycp2665, :ycp2666,
:ycp2667, :ycp2668)) AND (t.user_id IS NULL)) ORDER BY service_priority
DESC LIMIT 20 OFFSET 40)

end:system.db.CDbCommand.query(SELECT `t`.`service_id` AS `t0_c0`,
`t`.`service_name` AS `t0_c1`, `t`.`service_url` AS `t0_c2`,
`t`.`service_gradation_id` AS `t0_c3`, `t`.`user_id` AS `t0_c4`,
`t`.`service_priority` AS `t0_c5`, `t`.`service_date` AS `t0_c6`,
`t`.`service_banner` AS `t0_c7`, `serviceGradation`.`service_gradation_id`
AS `t1_c0`, `serviceGradation`.`service_gradation_name` AS `t1_c1` FROM
`services` `t`  STRAIGHT_JOIN `services_gradations` `serviceGradation` ON
(`t`.`service_gradation_id`=`serviceGradation`.`service_gradation_id`) 
WHERE ((t.service_id IN (:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6,
:ycp7, :ycp8, :ycp9, :ycp10, :ycp11, :ycp12, :ycp13, :ycp14, :ycp15,
:ycp16, :ycp17, :ycp18, :ycp19, :ycp20, :ycp21, :ycp22, :ycp23, :ycp24,
:ycp25, :ycp26, :ycp27, :ycp28, :ycp29, :ycp30, :ycp31, :ycp32, :ycp33,
:ycp34, :ycp35, :ycp36, :ycp37, :ycp38, :ycp39, :ycp40, :ycp41, :ycp42,
:ycp43, :ycp44, :ycp45, :ycp46, :ycp47, :ycp48, :ycp49, :ycp50, :ycp51,
:ycp52, :ycp53, :ycp54, :ycp55, :ycp56, :ycp57, :ycp58, :ycp59, :ycp60,
:ycp61, :ycp62, :ycp63, :ycp64, :ycp65, :ycp66, :ycp67, :ycp68, :ycp69,
:ycp70, :ycp71, :ycp72, :ycp73, :ycp74, :ycp75, :ycp76, :ycp77, :ycp78,
:ycp79, :ycp80, :ycp81, :ycp82, :ycp83, :ycp84, :ycp85, :ycp86, :ycp87,
:ycp88, :ycp89, :ycp90, :ycp91, :ycp92, :ycp93, :ycp94, :ycp95, :ycp96,
:ycp97, :ycp98, :ycp99, :ycp100, :ycp101, :ycp102, :ycp103, :ycp104,
:ycp105, :ycp106, :ycp107, :ycp108, :ycp109, :ycp110, :ycp111, :ycp112,
:ycp113, :ycp114, :ycp115, :ycp116, :ycp117, :ycp118, :ycp119, :ycp120,
:ycp121, :ycp122, :ycp123, :ycp124, :ycp125, :ycp126, :ycp127, :ycp128,
:ycp129, :ycp130, :ycp131, :ycp132, :ycp133, :ycp134, :ycp135, :ycp136,
:ycp137, :ycp138, :ycp139, :ycp140, :ycp141, :ycp142, :ycp143, :ycp144,
:ycp145, :ycp146, :ycp147, :ycp148, :ycp149, :ycp150, :ycp151, :ycp152,
:ycp153, :ycp154, :ycp155, :ycp156, :ycp157, :ycp158, :ycp159, :ycp160,
:ycp161, :ycp162, :ycp163, :ycp164, :ycp165, :ycp166, :ycp167, :ycp168,
:ycp169, :ycp170, :ycp171, :ycp172, :ycp173, :ycp174, :ycp175, :ycp176,
:ycp177, :ycp178, :ycp179, :ycp180, :ycp181, :ycp182, :ycp183, :ycp184,
:ycp185, :ycp186, :ycp187, :ycp188, :ycp189, :ycp190, :ycp191, :ycp192,
:ycp193, :ycp194, :ycp195, :ycp196, :ycp197, :ycp198, :ycp199, :ycp200,
:ycp201, :ycp202, :ycp203, :ycp204, :ycp205, :ycp206, :ycp207, :ycp208,
:ycp209, :ycp210, :ycp211, :ycp212, :ycp213, :ycp214, :ycp215, :ycp216,
:ycp217, :ycp218, :ycp219, :ycp220, :ycp221, :ycp222, :ycp223, :ycp224,
:ycp225, :ycp226, :ycp227, :ycp228, :ycp229, :ycp230, :ycp231, :ycp232,
:ycp233, :ycp234, :ycp235, :ycp236, :ycp237, :ycp238, :ycp239, :ycp240,
:ycp241, :ycp242, :ycp243, :ycp244, :ycp245, :ycp246, :ycp247, :ycp248,
:ycp249, :ycp250, :ycp251, :ycp252, :ycp253, :ycp254, :ycp255, :ycp256,
:ycp257, :ycp258, :ycp259, :ycp260, :ycp261, :ycp262, :ycp263, :ycp264,
:ycp265, :ycp266, :ycp267, :ycp268, :ycp269, :ycp270, :ycp271, :ycp272,
:ycp273, :ycp274, :ycp275, :ycp276, :ycp277, :ycp278, :ycp279, :ycp280,
:ycp281, :ycp282, :ycp283, :ycp284, :ycp285, :ycp286, :ycp287, :ycp288,
:ycp289, :ycp290, :ycp291, :ycp292, :ycp293, :ycp294, :ycp295, :ycp296,
:ycp297, :ycp298, :ycp299, :ycp300, :ycp301, :ycp302, :ycp303, :ycp304,
:ycp305, :ycp306, :ycp307, :ycp308, :ycp309, :ycp310, :ycp311, :ycp312,
:ycp313, :ycp314, :ycp315, :ycp316, :ycp317, :ycp318, :ycp319, :ycp320,
:ycp321, :ycp322, :ycp323, :ycp324, :ycp325, :ycp326, :ycp327, :ycp328,
:ycp329, :ycp330, :ycp331, :ycp332, :ycp333, :ycp334, :ycp335, :ycp336,
:ycp337, :ycp338, :ycp339, :ycp340, :ycp341, :ycp342, :ycp343, :ycp344,
:ycp345, :ycp346, :ycp347, :ycp348, :ycp349, :ycp350, :ycp351, :ycp352,
:ycp353, :ycp354, :ycp355, :ycp356, :ycp357, :ycp358, :ycp359, :ycp360,
:ycp361, :ycp362, :ycp363, :ycp364, :ycp365, :ycp366, :ycp367, :ycp368,
:ycp369, :ycp370, :ycp371, :ycp372, :ycp373, :ycp374, :ycp375, :ycp376,
:ycp377, :ycp378, :ycp379, :ycp380, :ycp381, :ycp382, :ycp383, :ycp384,
:ycp385, :ycp386, :ycp387, :ycp388, :ycp389, :ycp390, :ycp391, :ycp392,
:ycp393, :ycp394, :ycp395, :ycp396, :ycp397, :ycp398, :ycp399, :ycp400,
:ycp401, :ycp402, :ycp403, :ycp404, :ycp405, :ycp406, :ycp407, :ycp408,
:ycp409, :ycp410, :ycp411, :ycp412, :ycp413, :ycp414, :ycp415, :ycp416,
:ycp417, :ycp418, :ycp419, :ycp420, :ycp421, :ycp422, :ycp423, :ycp424,
:ycp425, :ycp426, :ycp427, :ycp428, :ycp429, :ycp430, :ycp431, :ycp432,
:ycp433, :ycp434, :ycp435, :ycp436, :ycp437, :ycp438, :ycp439, :ycp440,
:ycp441, :ycp442, :ycp443, :ycp444, :ycp445, :ycp446, :ycp447, :ycp448,
:ycp449, :ycp450, :ycp451, :ycp452, :ycp453, :ycp454, :ycp455, :ycp456,
:ycp457, :ycp458, :ycp459, :ycp460, :ycp461, :ycp462, :ycp463, :ycp464,
:ycp465, :ycp466, :ycp467, :ycp468, :ycp469, :ycp470, :ycp471, :ycp472,
:ycp473, :ycp474, :ycp475, :ycp476, :ycp477, :ycp478, :ycp479, :ycp480,
:ycp481, :ycp482, :ycp483, :ycp484, :ycp485, :ycp486, :ycp487, :ycp488,
:ycp489, :ycp490, :ycp491, :ycp492, :ycp493, :ycp494, :ycp495, :ycp496,
:ycp497, :ycp498, :ycp499, :ycp500, :ycp501, :ycp502, :ycp503, :ycp504,
:ycp505, :ycp506, :ycp507, :ycp508, :ycp509, :ycp510, :ycp511, :ycp512,
:ycp513, :ycp514, :ycp515, :ycp516, :ycp517, :ycp518, :ycp519, :ycp520,
:ycp521, :ycp522, :ycp523, :ycp524, :ycp525, :ycp526, :ycp527, :ycp528,
:ycp529, :ycp530, :ycp531, :ycp532, :ycp533, :ycp534, :ycp535, :ycp536,
:ycp537, :ycp538, :ycp539, :ycp540, :ycp541, :ycp542, :ycp543, :ycp544,
:ycp545, :ycp546, :ycp547, :ycp548, :ycp549, :ycp550, :ycp551, :ycp552,
:ycp553, :ycp554, :ycp555, :ycp556, :ycp557, :ycp558, :ycp559, :ycp560,
:ycp561, :ycp562, :ycp563, :ycp564, :ycp565, :ycp566, :ycp567, :ycp568,
:ycp569, :ycp570, :ycp571, :ycp572, :ycp573, :ycp574, :ycp575, :ycp576,
:ycp577, :ycp578, :ycp579, :ycp580, :ycp581, :ycp582, :ycp583, :ycp584,
:ycp585, :ycp586, :ycp587, :ycp588, :ycp589, :ycp590, :ycp591, :ycp592,
:ycp593, :ycp594, :ycp595, :ycp596, :ycp597, :ycp598, :ycp599, :ycp600,
:ycp601, :ycp602, :ycp603, :ycp604, :ycp605, :ycp606, :ycp607, :ycp608,
:ycp609, :ycp610, :ycp611, :ycp612, :ycp613, :ycp614, :ycp615, :ycp616,
:ycp617, :ycp618, :ycp619, :ycp620, :ycp621, :ycp622, :ycp623, :ycp624,
:ycp625, :ycp626, :ycp627, :ycp628, :ycp629, :ycp630, :ycp631, :ycp632,
:ycp633, :ycp634, :ycp635, :ycp636, :ycp637, :ycp638, :ycp639, :ycp640,
:ycp641, :ycp642, :ycp643, :ycp644, :ycp645, :ycp646, :ycp647, :ycp648,
:ycp649, :ycp650, :ycp651, :ycp652, :ycp653, :ycp654, :ycp655, :ycp656,
:ycp657, :ycp658, :ycp659, :ycp660, :ycp661, :ycp662, :ycp663, :ycp664,
:ycp665, :ycp666, :ycp667, :ycp668, :ycp669, :ycp670, :ycp671, :ycp672,
:ycp673, :ycp674, :ycp675, :ycp676, :ycp677, :ycp678, :ycp679, :ycp680,
:ycp681, :ycp682, :ycp683, :ycp684, :ycp685, :ycp686, :ycp687, :ycp688,
:ycp689, :ycp690, :ycp691, :ycp692, :ycp693, :ycp694, :ycp695, :ycp696,
:ycp697, :ycp698, :ycp699, :ycp700, :ycp701, :ycp702, :ycp703, :ycp704,
:ycp705, :ycp706, :ycp707, :ycp708, :ycp709, :ycp710, :ycp711, :ycp712,
:ycp713, :ycp714, :ycp715, :ycp716, :ycp717, :ycp718, :ycp719, :ycp720,
:ycp721, :ycp722, :ycp723, :ycp724, :ycp725, :ycp726, :ycp727, :ycp728,
:ycp729, :ycp730, :ycp731, :ycp732, :ycp733, :ycp734, :ycp735, :ycp736,
:ycp737, :ycp738, :ycp739, :ycp740, :ycp741, :ycp742, :ycp743, :ycp744,
:ycp745, :ycp746, :ycp747, :ycp748, :ycp749, :ycp750, :ycp751, :ycp752,
:ycp753, :ycp754, :ycp755, :ycp756, :ycp757, :ycp758, :ycp759, :ycp760,
:ycp761, :ycp762, :ycp763, :ycp764, :ycp765, :ycp766, :ycp767, :ycp768,
:ycp769, :ycp770, :ycp771, :ycp772, :ycp773, :ycp774, :ycp775, :ycp776,
:ycp777, :ycp778, :ycp779, :ycp780, :ycp781, :ycp782, :ycp783, :ycp784,
:ycp785, :ycp786, :ycp787, :ycp788, :ycp789, :ycp790, :ycp791, :ycp792,
:ycp793, :ycp794, :ycp795, :ycp796, :ycp797, :ycp798, :ycp799, :ycp800,
:ycp801, :ycp802, :ycp803, :ycp804, :ycp805, :ycp806, :ycp807, :ycp808,
:ycp809, :ycp810, :ycp811, :ycp812, :ycp813, :ycp814, :ycp815, :ycp816,
:ycp817, :ycp818, :ycp819, :ycp820, :ycp821, :ycp822, :ycp823, :ycp824,
:ycp825, :ycp826, :ycp827, :ycp828, :ycp829, :ycp830, :ycp831, :ycp832,
:ycp833, :ycp834, :ycp835, :ycp836, :ycp837, :ycp838, :ycp839, :ycp840,
:ycp841, :ycp842, :ycp843, :ycp844, :ycp845, :ycp846, :ycp847, :ycp848,
:ycp849, :ycp850, :ycp851, :ycp852, :ycp853, :ycp854, :ycp855, :ycp856,
:ycp857, :ycp858, :ycp859, :ycp860, :ycp861, :ycp862, :ycp863, :ycp864,
:ycp865, :ycp866, :ycp867, :ycp868, :ycp869, :ycp870, :ycp871, :ycp872,
:ycp873, :ycp874, :ycp875, :ycp876, :ycp877, :ycp878, :ycp879, :ycp880,
:ycp881, :ycp882, :ycp883, :ycp884, :ycp885, :ycp886, :ycp887, :ycp888,
:ycp889, :ycp890, :ycp891, :ycp892, :ycp893, :ycp894, :ycp895, :ycp896,
:ycp897, :ycp898, :ycp899, :ycp900, :ycp901, :ycp902, :ycp903, :ycp904,
:ycp905, :ycp906, :ycp907, :ycp908, :ycp909, :ycp910, :ycp911, :ycp912,
:ycp913, :ycp914, :ycp915, :ycp916, :ycp917, :ycp918, :ycp919, :ycp920,
:ycp921, :ycp922, :ycp923, :ycp924, :ycp925, :ycp926, :ycp927, :ycp928,
:ycp929, :ycp930, :ycp931, :ycp932, :ycp933, :ycp934, :ycp935, :ycp936,
:ycp937, :ycp938, :ycp939, :ycp940, :ycp941, :ycp942, :ycp943, :ycp944,
:ycp945, :ycp946, :ycp947, :ycp948, :ycp949, :ycp950, :ycp951, :ycp952,
:ycp953, :ycp954, :ycp955, :ycp956, :ycp957, :ycp958, :ycp959, :ycp960,
:ycp961, :ycp962, :ycp963, :ycp964, :ycp965, :ycp966, :ycp967, :ycp968,
:ycp969, :ycp970, :ycp971, :ycp972, :ycp973, :ycp974, :ycp975, :ycp976,
:ycp977, :ycp978, :ycp979, :ycp980, :ycp981, :ycp982, :ycp983, :ycp984,
:ycp985, :ycp986, :ycp987, :ycp988, :ycp989, :ycp990, :ycp991, :ycp992,
:ycp993, :ycp994, :ycp995, :ycp996, :ycp997, :ycp998, :ycp999, :ycp1000,
:ycp1001, :ycp1002, :ycp1003, :ycp1004, :ycp1005, :ycp1006, :ycp1007,
:ycp1008, :ycp1009, :ycp1010, :ycp1011, :ycp1012, :ycp1013, :ycp1014,
:ycp1015, :ycp1016, :ycp1017, :ycp1018, :ycp1019, :ycp1020, :ycp1021,
:ycp1022, :ycp1023, :ycp1024, :ycp1025, :ycp1026, :ycp1027, :ycp1028,
:ycp1029, :ycp1030, :ycp1031, :ycp1032, :ycp1033, :ycp1034, :ycp1035,
:ycp1036, :ycp1037, :ycp1038, :ycp1039, :ycp1040, :ycp1041, :ycp1042,
:ycp1043, :ycp1044, :ycp1045, :ycp1046, :ycp1047, :ycp1048, :ycp1049,
:ycp1050, :ycp1051, :ycp1052, :ycp1053, :ycp1054, :ycp1055, :ycp1056,
:ycp1057, :ycp1058, :ycp1059, :ycp1060, :ycp1061, :ycp1062, :ycp1063,
:ycp1064, :ycp1065, :ycp1066, :ycp1067, :ycp1068, :ycp1069, :ycp1070,
:ycp1071, :ycp1072, :ycp1073, :ycp1074, :ycp1075, :ycp1076, :ycp1077,
:ycp1078, :ycp1079, :ycp1080, :ycp1081, :ycp1082, :ycp1083, :ycp1084,
:ycp1085, :ycp1086, :ycp1087, :ycp1088, :ycp1089, :ycp1090, :ycp1091,
:ycp1092, :ycp1093, :ycp1094, :ycp1095, :ycp1096, :ycp1097, :ycp1098,
:ycp1099, :ycp1100, :ycp1101, :ycp1102, :ycp1103, :ycp1104, :ycp1105,
:ycp1106, :ycp1107, :ycp1108, :ycp1109, :ycp1110, :ycp1111, :ycp1112,
:ycp1113, :ycp1114, :ycp1115, :ycp1116, :ycp1117, :ycp1118, :ycp1119,
:ycp1120, :ycp1121, :ycp1122, :ycp1123, :ycp1124, :ycp1125, :ycp1126,
:ycp1127, :ycp1128, :ycp1129, :ycp1130, :ycp1131, :ycp1132, :ycp1133,
:ycp1134, :ycp1135, :ycp1136, :ycp1137, :ycp1138, :ycp1139, :ycp1140,
:ycp1141, :ycp1142, :ycp1143, :ycp1144, :ycp1145, :ycp1146, :ycp1147,
:ycp1148, :ycp1149, :ycp1150, :ycp1151, :ycp1152, :ycp1153, :ycp1154,
:ycp1155, :ycp1156, :ycp1157, :ycp1158, :ycp1159, :ycp1160, :ycp1161,
:ycp1162, :ycp1163, :ycp1164, :ycp1165, :ycp1166, :ycp1167, :ycp1168,
:ycp1169, :ycp1170, :ycp1171, :ycp1172, :ycp1173, :ycp1174, :ycp1175,
:ycp1176, :ycp1177, :ycp1178, :ycp1179, :ycp1180, :ycp1181, :ycp1182,
:ycp1183, :ycp1184, :ycp1185, :ycp1186, :ycp1187, :ycp1188, :ycp1189,
:ycp1190, :ycp1191, :ycp1192, :ycp1193, :ycp1194, :ycp1195, :ycp1196,
:ycp1197, :ycp1198, :ycp1199, :ycp1200, :ycp1201, :ycp1202, :ycp1203,
:ycp1204, :ycp1205, :ycp1206, :ycp1207, :ycp1208, :ycp1209, :ycp1210,
:ycp1211, :ycp1212, :ycp1213, :ycp1214, :ycp1215, :ycp1216, :ycp1217,
:ycp1218, :ycp1219, :ycp1220, :ycp1221, :ycp1222, :ycp1223, :ycp1224,
:ycp1225, :ycp1226, :ycp1227, :ycp1228, :ycp1229, :ycp1230, :ycp1231,
:ycp1232, :ycp1233, :ycp1234, :ycp1235, :ycp1236, :ycp1237, :ycp1238,
:ycp1239, :ycp1240, :ycp1241, :ycp1242, :ycp1243, :ycp1244, :ycp1245,
:ycp1246, :ycp1247, :ycp1248, :ycp1249, :ycp1250, :ycp1251, :ycp1252,
:ycp1253, :ycp1254, :ycp1255, :ycp1256, :ycp1257, :ycp1258, :ycp1259,
:ycp1260, :ycp1261, :ycp1262, :ycp1263, :ycp1264, :ycp1265, :ycp1266,
:ycp1267, :ycp1268, :ycp1269, :ycp1270, :ycp1271, :ycp1272, :ycp1273,
:ycp1274, :ycp1275, :ycp1276, :ycp1277, :ycp1278, :ycp1279, :ycp1280,
:ycp1281, :ycp1282, :ycp1283, :ycp1284, :ycp1285, :ycp1286, :ycp1287,
:ycp1288, :ycp1289, :ycp1290, :ycp1291, :ycp1292, :ycp1293, :ycp1294,
:ycp1295, :ycp1296, :ycp1297, :ycp1298, :ycp1299, :ycp1300, :ycp1301,
:ycp1302, :ycp1303, :ycp1304, :ycp1305, :ycp1306, :ycp1307, :ycp1308,
:ycp1309, :ycp1310, :ycp1311, :ycp1312, :ycp1313, :ycp1314, :ycp1315,
:ycp1316, :ycp1317, :ycp1318, :ycp1319, :ycp1320, :ycp1321, :ycp1322,
:ycp1323, :ycp1324, :ycp1325, :ycp1326, :ycp1327, :ycp1328, :ycp1329,
:ycp1330, :ycp1331, :ycp1332, :ycp1333, :ycp1334, :ycp1335, :ycp1336,
:ycp1337, :ycp1338, :ycp1339, :ycp1340, :ycp1341, :ycp1342, :ycp1343,
:ycp1344, :ycp1345, :ycp1346, :ycp1347, :ycp1348, :ycp1349, :ycp1350,
:ycp1351, :ycp1352, :ycp1353, :ycp1354, :ycp1355, :ycp1356, :ycp1357,
:ycp1358, :ycp1359, :ycp1360, :ycp1361, :ycp1362, :ycp1363, :ycp1364,
:ycp1365, :ycp1366, :ycp1367, :ycp1368, :ycp1369, :ycp1370, :ycp1371,
:ycp1372, :ycp1373, :ycp1374, :ycp1375, :ycp1376, :ycp1377, :ycp1378,
:ycp1379, :ycp1380, :ycp1381, :ycp1382, :ycp1383, :ycp1384, :ycp1385,
:ycp1386, :ycp1387, :ycp1388, :ycp1389, :ycp1390, :ycp1391, :ycp1392,
:ycp1393, :ycp1394, :ycp1395, :ycp1396, :ycp1397, :ycp1398, :ycp1399,
:ycp1400, :ycp1401, :ycp1402, :ycp1403, :ycp1404, :ycp1405, :ycp1406,
:ycp1407, :ycp1408, :ycp1409, :ycp1410, :ycp1411, :ycp1412, :ycp1413,
:ycp1414, :ycp1415, :ycp1416, :ycp1417, :ycp1418, :ycp1419, :ycp1420,
:ycp1421, :ycp1422, :ycp1423, :ycp1424, :ycp1425, :ycp1426, :ycp1427,
:ycp1428, :ycp1429, :ycp1430, :ycp1431, :ycp1432, :ycp1433, :ycp1434,
:ycp1435, :ycp1436, :ycp1437, :ycp1438, :ycp1439, :ycp1440, :ycp1441,
:ycp1442, :ycp1443, :ycp1444, :ycp1445, :ycp1446, :ycp1447, :ycp1448,
:ycp1449, :ycp1450, :ycp1451, :ycp1452, :ycp1453, :ycp1454, :ycp1455,
:ycp1456, :ycp1457, :ycp1458, :ycp1459, :ycp1460, :ycp1461, :ycp1462,
:ycp1463, :ycp1464, :ycp1465, :ycp1466, :ycp1467, :ycp1468, :ycp1469,
:ycp1470, :ycp1471, :ycp1472, :ycp1473, :ycp1474, :ycp1475, :ycp1476,
:ycp1477, :ycp1478, :ycp1479, :ycp1480, :ycp1481, :ycp1482, :ycp1483,
:ycp1484, :ycp1485, :ycp1486, :ycp1487, :ycp1488, :ycp1489, :ycp1490,
:ycp1491, :ycp1492, :ycp1493, :ycp1494, :ycp1495, :ycp1496, :ycp1497,
:ycp1498, :ycp1499, :ycp1500, :ycp1501, :ycp1502, :ycp1503, :ycp1504,
:ycp1505, :ycp1506, :ycp1507, :ycp1508, :ycp1509, :ycp1510, :ycp1511,
:ycp1512, :ycp1513, :ycp1514, :ycp1515, :ycp1516, :ycp1517, :ycp1518,
:ycp1519, :ycp1520, :ycp1521, :ycp1522, :ycp1523, :ycp1524, :ycp1525,
:ycp1526, :ycp1527, :ycp1528, :ycp1529, :ycp1530, :ycp1531, :ycp1532,
:ycp1533, :ycp1534, :ycp1535, :ycp1536, :ycp1537, :ycp1538, :ycp1539,
:ycp1540, :ycp1541, :ycp1542, :ycp1543, :ycp1544, :ycp1545, :ycp1546,
:ycp1547, :ycp1548, :ycp1549, :ycp1550, :ycp1551, :ycp1552, :ycp1553,
:ycp1554, :ycp1555, :ycp1556, :ycp1557, :ycp1558, :ycp1559, :ycp1560,
:ycp1561, :ycp1562, :ycp1563, :ycp1564, :ycp1565, :ycp1566, :ycp1567,
:ycp1568, :ycp1569, :ycp1570, :ycp1571, :ycp1572, :ycp1573, :ycp1574,
:ycp1575, :ycp1576, :ycp1577, :ycp1578, :ycp1579, :ycp1580, :ycp1581,
:ycp1582, :ycp1583, :ycp1584, :ycp1585, :ycp1586, :ycp1587, :ycp1588,
:ycp1589, :ycp1590, :ycp1591, :ycp1592, :ycp1593, :ycp1594, :ycp1595,
:ycp1596, :ycp1597, :ycp1598, :ycp1599, :ycp1600, :ycp1601, :ycp1602,
:ycp1603, :ycp1604, :ycp1605, :ycp1606, :ycp1607, :ycp1608, :ycp1609,
:ycp1610, :ycp1611, :ycp1612, :ycp1613, :ycp1614, :ycp1615, :ycp1616,
:ycp1617, :ycp1618, :ycp1619, :ycp1620, :ycp1621, :ycp1622, :ycp1623,
:ycp1624, :ycp1625, :ycp1626, :ycp1627, :ycp1628, :ycp1629, :ycp1630,
:ycp1631, :ycp1632, :ycp1633, :ycp1634, :ycp1635, :ycp1636, :ycp1637,
:ycp1638, :ycp1639, :ycp1640, :ycp1641, :ycp1642, :ycp1643, :ycp1644,
:ycp1645, :ycp1646, :ycp1647, :ycp1648, :ycp1649, :ycp1650, :ycp1651,
:ycp1652, :ycp1653, :ycp1654, :ycp1655, :ycp1656, :ycp1657, :ycp1658,
:ycp1659, :ycp1660, :ycp1661, :ycp1662, :ycp1663, :ycp1664, :ycp1665,
:ycp1666, :ycp1667, :ycp1668, :ycp1669, :ycp1670, :ycp1671, :ycp1672,
:ycp1673, :ycp1674, :ycp1675, :ycp1676, :ycp1677, :ycp1678, :ycp1679,
:ycp1680, :ycp1681, :ycp1682, :ycp1683, :ycp1684, :ycp1685, :ycp1686,
:ycp1687, :ycp1688, :ycp1689, :ycp1690, :ycp1691, :ycp1692, :ycp1693,
:ycp1694, :ycp1695, :ycp1696, :ycp1697, :ycp1698, :ycp1699, :ycp1700,
:ycp1701, :ycp1702, :ycp1703, :ycp1704, :ycp1705, :ycp1706, :ycp1707,
:ycp1708, :ycp1709, :ycp1710, :ycp1711, :ycp1712, :ycp1713, :ycp1714,
:ycp1715, :ycp1716, :ycp1717, :ycp1718, :ycp1719, :ycp1720, :ycp1721,
:ycp1722, :ycp1723, :ycp1724, :ycp1725, :ycp1726, :ycp1727, :ycp1728,
:ycp1729, :ycp1730, :ycp1731, :ycp1732, :ycp1733, :ycp1734, :ycp1735,
:ycp1736, :ycp1737, :ycp1738, :ycp1739, :ycp1740, :ycp1741, :ycp1742,
:ycp1743, :ycp1744, :ycp1745, :ycp1746, :ycp1747, :ycp1748, :ycp1749,
:ycp1750, :ycp1751, :ycp1752, :ycp1753, :ycp1754, :ycp1755, :ycp1756,
:ycp1757, :ycp1758, :ycp1759, :ycp1760, :ycp1761, :ycp1762, :ycp1763,
:ycp1764, :ycp1765, :ycp1766, :ycp1767, :ycp1768, :ycp1769, :ycp1770,
:ycp1771, :ycp1772, :ycp1773, :ycp1774, :ycp1775, :ycp1776, :ycp1777,
:ycp1778, :ycp1779, :ycp1780, :ycp1781, :ycp1782, :ycp1783, :ycp1784,
:ycp1785, :ycp1786, :ycp1787, :ycp1788, :ycp1789, :ycp1790, :ycp1791,
:ycp1792, :ycp1793, :ycp1794, :ycp1795, :ycp1796, :ycp1797, :ycp1798,
:ycp1799, :ycp1800, :ycp1801, :ycp1802, :ycp1803, :ycp1804, :ycp1805,
:ycp1806, :ycp1807, :ycp1808, :ycp1809, :ycp1810, :ycp1811, :ycp1812,
:ycp1813, :ycp1814, :ycp1815, :ycp1816, :ycp1817, :ycp1818, :ycp1819,
:ycp1820, :ycp1821, :ycp1822, :ycp1823, :ycp1824, :ycp1825, :ycp1826,
:ycp1827, :ycp1828, :ycp1829, :ycp1830, :ycp1831, :ycp1832, :ycp1833,
:ycp1834, :ycp1835, :ycp1836, :ycp1837, :ycp1838, :ycp1839, :ycp1840,
:ycp1841, :ycp1842, :ycp1843, :ycp1844, :ycp1845, :ycp1846, :ycp1847,
:ycp1848, :ycp1849, :ycp1850, :ycp1851, :ycp1852, :ycp1853, :ycp1854,
:ycp1855, :ycp1856, :ycp1857, :ycp1858, :ycp1859, :ycp1860, :ycp1861,
:ycp1862, :ycp1863, :ycp1864, :ycp1865, :ycp1866, :ycp1867, :ycp1868,
:ycp1869, :ycp1870, :ycp1871, :ycp1872, :ycp1873, :ycp1874, :ycp1875,
:ycp1876, :ycp1877, :ycp1878, :ycp1879, :ycp1880, :ycp1881, :ycp1882,
:ycp1883, :ycp1884, :ycp1885, :ycp1886, :ycp1887, :ycp1888, :ycp1889,
:ycp1890, :ycp1891, :ycp1892, :ycp1893, :ycp1894, :ycp1895, :ycp1896,
:ycp1897, :ycp1898, :ycp1899, :ycp1900, :ycp1901, :ycp1902, :ycp1903,
:ycp1904, :ycp1905, :ycp1906, :ycp1907, :ycp1908, :ycp1909, :ycp1910,
:ycp1911, :ycp1912, :ycp1913, :ycp1914, :ycp1915, :ycp1916, :ycp1917,
:ycp1918, :ycp1919, :ycp1920, :ycp1921, :ycp1922, :ycp1923, :ycp1924,
:ycp1925, :ycp1926, :ycp1927, :ycp1928, :ycp1929, :ycp1930, :ycp1931,
:ycp1932, :ycp1933, :ycp1934, :ycp1935, :ycp1936, :ycp1937, :ycp1938,
:ycp1939, :ycp1940, :ycp1941, :ycp1942, :ycp1943, :ycp1944, :ycp1945,
:ycp1946, :ycp1947, :ycp1948, :ycp1949, :ycp1950, :ycp1951, :ycp1952,
:ycp1953, :ycp1954, :ycp1955, :ycp1956, :ycp1957, :ycp1958, :ycp1959,
:ycp1960, :ycp1961, :ycp1962, :ycp1963, :ycp1964, :ycp1965, :ycp1966,
:ycp1967, :ycp1968, :ycp1969, :ycp1970, :ycp1971, :ycp1972, :ycp1973,
:ycp1974, :ycp1975, :ycp1976, :ycp1977, :ycp1978, :ycp1979, :ycp1980,
:ycp1981, :ycp1982, :ycp1983, :ycp1984, :ycp1985, :ycp1986, :ycp1987,
:ycp1988, :ycp1989, :ycp1990, :ycp1991, :ycp1992, :ycp1993, :ycp1994,
:ycp1995, :ycp1996, :ycp1997, :ycp1998, :ycp1999, :ycp2000, :ycp2001,
:ycp2002, :ycp2003, :ycp2004, :ycp2005, :ycp2006, :ycp2007, :ycp2008,
:ycp2009, :ycp2010, :ycp2011, :ycp2012, :ycp2013, :ycp2014, :ycp2015,
:ycp2016, :ycp2017, :ycp2018, :ycp2019, :ycp2020, :ycp2021, :ycp2022,
:ycp2023, :ycp2024, :ycp2025, :ycp2026, :ycp2027, :ycp2028, :ycp2029,
:ycp2030, :ycp2031, :ycp2032, :ycp2033, :ycp2034, :ycp2035, :ycp2036,
:ycp2037, :ycp2038, :ycp2039, :ycp2040, :ycp2041, :ycp2042, :ycp2043,
:ycp2044, :ycp2045, :ycp2046, :ycp2047, :ycp2048, :ycp2049, :ycp2050,
:ycp2051, :ycp2052, :ycp2053, :ycp2054, :ycp2055, :ycp2056, :ycp2057,
:ycp2058, :ycp2059, :ycp2060, :ycp2061, :ycp2062, :ycp2063, :ycp2064,
:ycp2065, :ycp2066, :ycp2067, :ycp2068, :ycp2069, :ycp2070, :ycp2071,
:ycp2072, :ycp2073, :ycp2074, :ycp2075, :ycp2076, :ycp2077, :ycp2078,
:ycp2079, :ycp2080, :ycp2081, :ycp2082, :ycp2083, :ycp2084, :ycp2085,
:ycp2086, :ycp2087, :ycp2088, :ycp2089, :ycp2090, :ycp2091, :ycp2092,
:ycp2093, :ycp2094, :ycp2095, :ycp2096, :ycp2097, :ycp2098, :ycp2099,
:ycp2100, :ycp2101, :ycp2102, :ycp2103, :ycp2104, :ycp2105, :ycp2106,
:ycp2107, :ycp2108, :ycp2109, :ycp2110, :ycp2111, :ycp2112, :ycp2113,
:ycp2114, :ycp2115, :ycp2116, :ycp2117, :ycp2118, :ycp2119, :ycp2120,
:ycp2121, :ycp2122, :ycp2123, :ycp2124, :ycp2125, :ycp2126, :ycp2127,
:ycp2128, :ycp2129, :ycp2130, :ycp2131, :ycp2132, :ycp2133, :ycp2134,
:ycp2135, :ycp2136, :ycp2137, :ycp2138, :ycp2139, :ycp2140, :ycp2141,
:ycp2142, :ycp2143, :ycp2144, :ycp2145, :ycp2146, :ycp2147, :ycp2148,
:ycp2149, :ycp2150, :ycp2151, :ycp2152, :ycp2153, :ycp2154, :ycp2155,
:ycp2156, :ycp2157, :ycp2158, :ycp2159, :ycp2160, :ycp2161, :ycp2162,
:ycp2163, :ycp2164, :ycp2165, :ycp2166, :ycp2167, :ycp2168, :ycp2169,
:ycp2170, :ycp2171, :ycp2172, :ycp2173, :ycp2174, :ycp2175, :ycp2176,
:ycp2177, :ycp2178, :ycp2179, :ycp2180, :ycp2181, :ycp2182, :ycp2183,
:ycp2184, :ycp2185, :ycp2186, :ycp2187, :ycp2188, :ycp2189, :ycp2190,
:ycp2191, :ycp2192, :ycp2193, :ycp2194, :ycp2195, :ycp2196, :ycp2197,
:ycp2198, :ycp2199, :ycp2200, :ycp2201, :ycp2202, :ycp2203, :ycp2204,
:ycp2205, :ycp2206, :ycp2207, :ycp2208, :ycp2209, :ycp2210, :ycp2211,
:ycp2212, :ycp2213, :ycp2214, :ycp2215, :ycp2216, :ycp2217, :ycp2218,
:ycp2219, :ycp2220, :ycp2221, :ycp2222, :ycp2223, :ycp2224, :ycp2225,
:ycp2226, :ycp2227, :ycp2228, :ycp2229, :ycp2230, :ycp2231, :ycp2232,
:ycp2233, :ycp2234, :ycp2235, :ycp2236, :ycp2237, :ycp2238, :ycp2239,
:ycp2240, :ycp2241, :ycp2242, :ycp2243, :ycp2244, :ycp2245, :ycp2246,
:ycp2247, :ycp2248, :ycp2249, :ycp2250, :ycp2251, :ycp2252, :ycp2253,
:ycp2254, :ycp2255, :ycp2256, :ycp2257, :ycp2258, :ycp2259, :ycp2260,
:ycp2261, :ycp2262, :ycp2263, :ycp2264, :ycp2265, :ycp2266, :ycp2267,
:ycp2268, :ycp2269, :ycp2270, :ycp2271, :ycp2272, :ycp2273, :ycp2274,
:ycp2275, :ycp2276, :ycp2277, :ycp2278, :ycp2279, :ycp2280, :ycp2281,
:ycp2282, :ycp2283, :ycp2284, :ycp2285, :ycp2286, :ycp2287, :ycp2288,
:ycp2289, :ycp2290, :ycp2291, :ycp2292, :ycp2293, :ycp2294, :ycp2295,
:ycp2296, :ycp2297, :ycp2298, :ycp2299, :ycp2300, :ycp2301, :ycp2302,
:ycp2303, :ycp2304, :ycp2305, :ycp2306, :ycp2307, :ycp2308, :ycp2309,
:ycp2310, :ycp2311, :ycp2312, :ycp2313, :ycp2314, :ycp2315, :ycp2316,
:ycp2317, :ycp2318, :ycp2319, :ycp2320, :ycp2321, :ycp2322, :ycp2323,
:ycp2324, :ycp2325, :ycp2326, :ycp2327, :ycp2328, :ycp2329, :ycp2330,
:ycp2331, :ycp2332, :ycp2333, :ycp2334, :ycp2335, :ycp2336, :ycp2337,
:ycp2338, :ycp2339, :ycp2340, :ycp2341, :ycp2342, :ycp2343, :ycp2344,
:ycp2345, :ycp2346, :ycp2347, :ycp2348, :ycp2349, :ycp2350, :ycp2351,
:ycp2352, :ycp2353, :ycp2354, :ycp2355, :ycp2356, :ycp2357, :ycp2358,
:ycp2359, :ycp2360, :ycp2361, :ycp2362, :ycp2363, :ycp2364, :ycp2365,
:ycp2366, :ycp2367, :ycp2368, :ycp2369, :ycp2370, :ycp2371, :ycp2372,
:ycp2373, :ycp2374, :ycp2375, :ycp2376, :ycp2377, :ycp2378, :ycp2379,
:ycp2380, :ycp2381, :ycp2382, :ycp2383, :ycp2384, :ycp2385, :ycp2386,
:ycp2387, :ycp2388, :ycp2389, :ycp2390, :ycp2391, :ycp2392, :ycp2393,
:ycp2394, :ycp2395, :ycp2396, :ycp2397, :ycp2398, :ycp2399, :ycp2400,
:ycp2401, :ycp2402, :ycp2403, :ycp2404, :ycp2405, :ycp2406, :ycp2407,
:ycp2408, :ycp2409, :ycp2410, :ycp2411, :ycp2412, :ycp2413, :ycp2414,
:ycp2415, :ycp2416, :ycp2417, :ycp2418, :ycp2419, :ycp2420, :ycp2421,
:ycp2422, :ycp2423, :ycp2424, :ycp2425, :ycp2426, :ycp2427, :ycp2428,
:ycp2429, :ycp2430, :ycp2431, :ycp2432, :ycp2433, :ycp2434, :ycp2435,
:ycp2436, :ycp2437, :ycp2438, :ycp2439, :ycp2440, :ycp2441, :ycp2442,
:ycp2443, :ycp2444, :ycp2445, :ycp2446, :ycp2447, :ycp2448, :ycp2449,
:ycp2450, :ycp2451, :ycp2452, :ycp2453, :ycp2454, :ycp2455, :ycp2456,
:ycp2457, :ycp2458, :ycp2459, :ycp2460, :ycp2461, :ycp2462, :ycp2463,
:ycp2464, :ycp2465, :ycp2466, :ycp2467, :ycp2468, :ycp2469, :ycp2470,
:ycp2471, :ycp2472, :ycp2473, :ycp2474, :ycp2475, :ycp2476, :ycp2477,
:ycp2478, :ycp2479, :ycp2480, :ycp2481, :ycp2482, :ycp2483, :ycp2484,
:ycp2485, :ycp2486, :ycp2487, :ycp2488, :ycp2489, :ycp2490, :ycp2491,
:ycp2492, :ycp2493, :ycp2494, :ycp2495, :ycp2496, :ycp2497, :ycp2498,
:ycp2499, :ycp2500, :ycp2501, :ycp2502, :ycp2503, :ycp2504, :ycp2505,
:ycp2506, :ycp2507, :ycp2508, :ycp2509, :ycp2510, :ycp2511, :ycp2512,
:ycp2513, :ycp2514, :ycp2515, :ycp2516, :ycp2517, :ycp2518, :ycp2519,
:ycp2520, :ycp2521, :ycp2522, :ycp2523, :ycp2524, :ycp2525, :ycp2526,
:ycp2527, :ycp2528, :ycp2529, :ycp2530, :ycp2531, :ycp2532, :ycp2533,
:ycp2534, :ycp2535, :ycp2536, :ycp2537, :ycp2538, :ycp2539, :ycp2540,
:ycp2541, :ycp2542, :ycp2543, :ycp2544, :ycp2545, :ycp2546, :ycp2547,
:ycp2548, :ycp2549, :ycp2550, :ycp2551, :ycp2552, :ycp2553, :ycp2554,
:ycp2555, :ycp2556, :ycp2557, :ycp2558, :ycp2559, :ycp2560, :ycp2561,
:ycp2562, :ycp2563, :ycp2564, :ycp2565, :ycp2566, :ycp2567, :ycp2568,
:ycp2569, :ycp2570, :ycp2571, :ycp2572, :ycp2573, :ycp2574, :ycp2575,
:ycp2576, :ycp2577, :ycp2578, :ycp2579, :ycp2580, :ycp2581, :ycp2582,
:ycp2583, :ycp2584, :ycp2585, :ycp2586, :ycp2587, :ycp2588, :ycp2589,
:ycp2590, :ycp2591, :ycp2592, :ycp2593, :ycp2594, :ycp2595, :ycp2596,
:ycp2597, :ycp2598, :ycp2599, :ycp2600, :ycp2601, :ycp2602, :ycp2603,
:ycp2604, :ycp2605, :ycp2606, :ycp2607, :ycp2608, :ycp2609, :ycp2610,
:ycp2611, :ycp2612, :ycp2613, :ycp2614, :ycp2615, :ycp2616, :ycp2617,
:ycp2618, :ycp2619, :ycp2620, :ycp2621, :ycp2622, :ycp2623, :ycp2624,
:ycp2625, :ycp2626, :ycp2627, :ycp2628, :ycp2629, :ycp2630, :ycp2631,
:ycp2632, :ycp2633, :ycp2634, :ycp2635, :ycp2636, :ycp2637, :ycp2638,
:ycp2639, :ycp2640, :ycp2641, :ycp2642, :ycp2643, :ycp2644, :ycp2645,
:ycp2646, :ycp2647, :ycp2648, :ycp2649, :ycp2650, :ycp2651, :ycp2652,
:ycp2653, :ycp2654, :ycp2655, :ycp2656, :ycp2657, :ycp2658, :ycp2659,
:ycp2660, :ycp2661, :ycp2662, :ycp2663, :ycp2664, :ycp2665, :ycp2666,
:ycp2667, :ycp2668)) AND (t.user_id IS NULL)) ORDER BY service_priority
DESC LIMIT 20 OFFSET 40)

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:users" from
cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:geo_regions"
from cache

Users.count() eagerly

Serving "yii:dbquerymysql:host=localhost;dbname=omastere_db:omastere:SELECT
COUNT(DISTINCT `t`.`user_id`) FROM `users` `t`  LEFT OUTER JOIN
`geo_cities` `city` ON (`t`.`city_id`=`city`.`city_id`)  LEFT OUTER JOIN
`geo_regions` `region` ON (`city`.`region_id`=`region`.`region_id`)  WHERE
(t.user_type <> 1 AND region.country_id =
:country_id):a:1:{s:11:":country_id";s:1:"1";}" from cache

Serving
"yii:dbschemamysql:host=localhost;dbname=omastere_db:omastere:tenders" from
cache

Tenders.count() eagerly

Serving "yii:dbquerymysql:host=localhost;dbname=omastere_db:omastere:SELECT
COUNT(DISTINCT `t`.`tender_id`) FROM `tenders` `t`  LEFT OUTER JOIN
`geo_cities` `city` ON (`t`.`city_id`=`city`.`city_id`)  LEFT OUTER JOIN
`geo_regions` `region` ON (`city`.`region_id`=`region`.`region_id`)  WHERE
(region.country_id = :country_id):a:1:{s:11:":country_id";s:1:"1";}" from
cache

Serving "yii:dbquerymysql:host=localhost;dbname=omastere_db:omastere:SELECT
COUNT(*) FROM `services` `t` WHERE t.user_id IS NULL:a:0:{}" from cache