Through the request UNION♪ Picking the 10s you need, supplementing 10 unnecessary, selecting the first 10SELECT * FROM ( SELECT 0 AS `order`, * FROM my_table WHERE some_field = 1 LIMIT 10 UNION SELECT 1 AS `order`, * FROM my_table WHERE some_field <> 1 LIMIT 10 ) sub ORDER BY `order` LIMIT 10

The problem is "unrecognized selector sent to instance 0x608000039620, i.e. an unidentified sector. Probably in the name of the POST method.let requestUpdate = client.urlRequest(withMethod: "POST", url: statusesShowEndpointUpdate, parameters: parameters, error: &clientError)

You can do that. But don't mix "right" with "great." It doesn't have to be done on the request. In front of him. Why do you want to start a heavy compliance request?Let's say you have a request of this kind:SELECT `table1`.* FROM `table1` INNER JOIN `table2` ON (`table1`.`tb2_id` = `table2`.`id`) ... Before it is carried out, they are:SELECT COUNT(`table1`.`id`) FROM `table1` INNER JOIN `table2` ON (`table1`.`tb2_id` = `table2`.`id`) // по возможности убирая излишние JOIN-ы ...

Everything just came up. 1 Option: Add several fields to usopt. When adding the post or comment, increase/decrease the ring counter. Then, without joining, you can get a bell. But it doesn't fit the rules.2 Option: create a separate box for posts, comments, photoc. Added post, comment, + or counter, and then join’o to receive these quantities.It was so simple.

We need to change the name at the input. name="lg[]"Then, $_REQUEST['lg'] range of selected valuesUPD Updated your code, but you have to think about optimizing the decision and refacturing.<form action="" method="GET"> <p>html<input type="checkbox" name="lg[]" value="1"></p> <p>css<input type="checkbox" name="lg[]" value="2"></p> <p>php<input type="checkbox" name="lg[]" value="3"></p> <p>javascript<input type="checkbox" name="lg[]" value="4"></p> <input type="submit"> </form> <?php $str = 'Вы знаете: '; if(isset($_REQUEST['lg'])) { if(in_array(1, $_REQUEST['lg'])) { $str .= 'html.'; } if(in_array(2, $_REQUEST['lg'])) { $str .= 'css.'; } if(in_array(3, $_REQUEST['lg'])) { $str .= 'php.'; } if(in_array(4, $_REQUEST['lg'])) { $str .= 'javascript.'; } } echo $str; ?>

Duck and write the request exactly as he describes in the text. Choose those lines that accept the values no answer and then delete those that ever accept answered♪ SELECT count(distinct id) FROM data WHERE disp = 'NO ANSWER' AND id not in ( SELECT distinct id FROM data WHERE disp = 'ANSWERED' )

For example:SELECT t1.*, ( SELECT COUNT(*) cnt FROM table3 t3 WHERE t3.target_id = t1.id HAVING cnt > 2 ) mycount FROM table1 t1, table2 t2 WHERE t.id1 = t2.id2 ORDER BY mycount LIMIT 10 Or so:SELECT t1.*, t3.count FROM table1 t1, table2 t2, ( SELECT target_id, COUNT(*) mycount FROM table3 GROUP BY target_id HAVING mycount > 2 ) t3 WHERE t1.id1 = t2.id2 and t3.target_id = t.id ORDER BY t3.mycount LIMIT 10

select id_reg, reg1, max(grafic) as grafic, max(potr) port, max(kolob) kloob from ( ваш-большой-запрос ) A group by id_reg, reg1 P.S. text Request:r.id_reg>1 AND r.id_reg<>10 AND r.id_reg<>20 ... rewrite how r.id_reg>1 AND r.id_reg not in(10,20,30,40,12,13) - just shorter and better.The beginning of the second part of the main request is to simplify:SELECT idreg, reg1, NULL AS t2, NULL AS t1, (SELECT COUNT( * ) FROM kartosn k WHERE k.obdate &gt; 2006-01-01 AND k.subord&gt;=subr AND k.subord&lt;sebr ) AS grafik, COUNT(idreg) AS potr, SUM(ografik)+SUM(cgrafik) AS kolob In the deepest sub-request for the second part, columns such as subr, sebr, pasobdate (separate sub-request) are selected, but no further use is made; they may be removed unless they are necessary in the external layers of the request in the future.

I assume you have a table of products that already have records of these ids, and you want to put these rows in a related table of images. If so, you can write something like:INSERT INTO `catalogue_productimage` (`id`, `original`, `caption`, `display_order`, `date_created`, `product_id`) select id, 'images/products/2016/09/none.png', '', 0, '2016-09-29 11:07:36', id from products where id between 1 and 1261 If no such table is available, the same table may be used. catalogue_productimage♪ To this end, your first record is inserted into it, and the next few requests like this (if only one entry is in the table):INSERT INTO `catalogue_productimage` (`id`, `original`, `caption`, `display_order`, `date_created`, `product_id`) select id+1, original, caption, display_order, date_created, id+1 from catalogue_productimage; INSERT INTO catalogue_productimage (id, original, caption, display_order, date_created, product_id) select id+2, original, caption, display_order, date_created, id+2 from catalogue_productimage; INSERT INTO catalogue_productimage (id, original, caption, display_order, date_created, product_id) select id+4, original, caption, display_order, date_created, id+4 from catalogue_productimage; The trick is, every subsequent request creates twice as many records as the previous one, so we're gonna need not more than 11 requests to reach around 1261. Requests are different only with additives to ID. In the last request, we're gonna have to limit the maximum id, so the request will get a condition. where id<=1261-1024♪

Reclassify the class and turn off http://www.yiiframework.com/doc/api/1.1/CHttpSession#autoStart-detail of the session, provided that:class DbHttpSession extends CDbHttpSession{ public function init() { if($this-&gt;isMobile()){ $this-&gt;autoStart = false; } parent::init(); } public function isMobile(){ //... return true; } //... } Indicate your class in the configuration file:'session' => array( 'class' => 'application.components.DbHttpSession', //... ),

def exportStats(request): _type = request.GET.get('type', 'all') It's just a dictionary. You can put any weight in it. In this case: request.GET['type'] = "моё значение" def compareStats(request): data1 = get_stats(request) request.GET = {'type': "мои параметры", } data2 = get_stats(request) def compareStats(request): data1 = get_stats(request) # чтобы сделать QueryDict изменяемым надо выполнить его метод copy() request.GET = request.GET.copy() request.GET['type'] = "Мои параметры" data2 = get_stats(request) If, of course, there's no way to correct the interface get_stats, it's probably the most right thing to do.

No structure objrts I'm sure you can't answer, but you probably have too many elements in your line. Try to clean up a few diaries.

It's possible to take the data first. Buffer♪ This requires a call. request with parameter encoding: null♪ The page itself is given as 'text/html; charset=CP1251'respectively and decode You should do it. win1251♪This should work:var req = require("request"); var iconv = require('iconv-lite'); req( { url: "http://sluchajnoe.ru/slovo.php", encoding: null }, function (error, res, body){ var wordRandom = iconv.decode(body, "win1251"); wordRandom = wordRandom.replace(/&lt;font size="200%"&gt;(.+)/gi, function(match, p1){ console.log(p1); return p1; }); });

As specified https://docs.angularjs.org/api/ngResource/service/%24resource request can be cancelled by means of a function $cancelRequest♪ To this end, an option should be added to the method cancellable♪This parameter works for the version, starting with 1.5.0♪Example https://jsfiddle.net/Stepan_Kasyanenko/9dcdqx68/ ♪angular.module('ExampleApp', ['ngResource']) .controller('ExampleController', function(ExampleService) { var vm = this; //Массив для отображения информации о запросах vm.request = []; vm.start = function() { vm.cancel(); //Отменяем предыдущий запрос ExampleService.getData(1).$promise .then(function() { console.log('success'); }) .catch(function(data) { console.log('catch', data); vm.request.push(data); }); }; vm.cancel = function() { if (ExampleService.getData.$promise) ExampleService.getData.$promise.$cancelRequest(); }; }) .service('ExampleService', function($resource) { var Example = $resource("/data/:id", { id: "@id" }, { // Let's make the `query()` method cancellable query: { method: 'get', isArray: true, cancellable: true } }); return { getData: function(id) { // Сохраняем промис для отмены this.getData.$promise = Example.query({ id: id }); return this.getData.$promise; } } });<script src="https://cdnjs.cloudflare.com/ajax/libs/angular.js/1.5.8/angular.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/angular.js/1.5.8/angular-resource.js"></script> <div ng-app="ExampleApp"> <div ng-controller="ExampleController as vm"> <button ng-click="vm.start()"> Start Request </button> <button ng-click="vm.cancel()"> Cancel Request </button> <div ng-repeat="req in vm.request"> <pre>{{$index}}: status = {{req.status}} statusText = {{req.status==-1?"Cancelled":req.statusText}}</pre> </div> </div> </div>Unfortunately, the snipe doesn't work. But the code is working and jsfiddle, too.

SELECT DATE_FORMAT(`orders`.`date`, '%d.%m.%Y') AS `date`, COUNT(`id`) AS `count` FROM `orders` WHERE `orders`.`status` = 1 AND `orders`.`date` >= '2016-09-08' AND `orders`.`date` <= ('2016-09-11' + INTERVAL 1 DAY) GROUP BY DATE_FORMAT(`orders`.`date`, '%d.%m.%Y') ORDER BY `orders`.`date` DESC

Samples from one tableWe'll take a user table with personal information, Indicated to e-mail. Here's a couple of sheets. Conditions that can benefit from indices:EmailAddress = 'vasya.pupkin@mail.ru' wrote the same thing instead of LIKE. I don't know how surprised EXPLAIN's results are. Research - definitely relevant is always possible Use the index, server goes through the tree and gets the exact Indication of the recording or several entries in the table. Right away. To note that by defining the column unique, it is automatically created the index. Why? Otherwise, it would be written in front of each box or check all field values The condition of uniqueness, and it's so fast to verify the existence records. EmailAddress LIKE 'vacya.pupkin@%' - partial use index. Repeat that the extreme left part should be defined and Only it can be used to search for indices. For example, EmailAddress LIKE 'vasya.%@mail.ru' will also be used index, but only will be involved in searching the index structure vasya. The rest will be checked in a consistent manner scanning the lines found by the index. For example, return to the consideration of the characteristics of the composite indices. The same. Number of operations: equality, more less than others. It is not reasonable to know that certain conditions can be met. lead to alternative expressions using elementary operations such as BETWEEN, which is also optimized.(sighs) http://xpoint.ru/know-how/MySQL/Optimizatsiya/Indeksyi )In that case, you use the directive. USE INDEX or FORCE INDEX♪UPD As an optimization, you can also try the request instead of a sample of all fields, "*", list only those fields you really need. This will reduce the number of selected and relayed data.

Use that technology, you know well.and of course it should be popular enough to be easy to find a developer. I'll describe a fairly typical situation: The server system normally consists of a fairly large number of related components, that is: databases,In line,Web servers,Proxy servers, balancers,monitoring systems, ReservesAll this needs to be deployed, built, filled with test data. And then periodically update and reassemble, as many components are actively developed. By the way, the complexity and heterogeneity of the server system requires that this complexity be managed. These are all possible systems of deployment, management, configuration, monitoring, diagnosis, collection, analysis and storage of logs. The development of these infrastructure components sometimes involves a lion &apos; s share of effort and time.Don't forget the scale. When there's a serious user outfit. Loading on the server system is increasing. One of the subsystems (usually the database) is slightly degraded due to the increased workload, starting to respond slowly, or at all, reset the response time. As a result, there is an increase in the overall processing time of one request on the business logic server, which in turn leads to an increase in the number of simultaneous processors. The server ends free memory, the operating system, trying to serve an increased number of processes, is now mainly concerned with changing contexts and moving pages into memory. That makes things worse. This is the case with the balancer, throwing out the load of the downloading server, thereby increasing the load on the remaining servers. Congratulations, our landing site, and lifting it without taking the load off will be very problematic.It is understandable that such situations usually occur only at the very beginning of a new service. In the future, either the developers rectify the system &apos; s deficiency or the service is gradually being lost.In order to successfully survive such excesses, the server software should be sufficiently “elementary” and ambitious. Then the increase in load will not result in the total failure of the service, but, for example, only a slight degradation at the speed of processing requests. In such a case, the temporary increase in the load can only be delayed, and if the load has increased permanently (i.e., the service has become more popular), it is sufficient to compensate for it by delivering the required number of servers. At times, the architecture of the whole application must be seriously redesigned, targeting and removing the most narrow parts of the system.

That's it. SetSystemTime Windows API.Details - https://msdn.microsoft.com/ru-ru/library/windows/desktop/ms724942%28v=vs.85%29.aspx ♪I must also write that the class of the class is considered extremely unhealthy. ♪ ♪

You can read it. http://djbook.ru/rel1.9/ref/templates/language.html#automatic-html-escaping The fact that the point is replaced by the comma is possible to improve the readability of the jang, but the operations must nevertheless be accessible as normal.In Django, each template screens all variables. In particular, such replacements are performed:< заменяется на &lt; > заменяется на &gt; ' (одинарная кавычка) заменяется на &#39; " (двойная кавычка) заменяется на &quot; & заменяется на &amp; Use a safe filter to disable auto-equipment for individual variables:This will be escaped: {{ data }} This will not be escaped: {{ data|safe }}

$rows = (new Query())->from('vote')->where(['poll_id' => $id])->sum('count');