Андрей Ежгуров

$route = isset($_GET['route']) ? $_GET['route'] : '';

wp_deregister_script('jquery');
wp_enqueue_script('jquery', 'https://code.jquery.com/jquery.min.js', [], null, true);

$.ajax({
    url: 'http://127.0.0.1:8080/login',
    type: 'POST',
    data: JSON.stringify({
        username : 'rob6',
        password : '9292271A'
    }),
    beforeSend: function (xhr) {
        xhr.setRequestHeader("Content-Type", 'application/json;charset=UTF-8');
    },
    dataType: 'json',
    success: function(response){
        console.log(response)
    },
    error: function(response){
        console.log(response)
    }
});

SUM(CASE WHEN v.direct = 'UP' THEN 1 ELSE -1 END) AS post_rate

SUM(CASE WHEN v.direct = 'UP' THEN 1 WHEN v.direct = 'DOWN' THEN -1 ELSE 0 END) AS post_rate

SELECT DISTINCT comment.*
FROM comment
INNER JOIN parent_child_comment
  ON parent_child_comment.child_comment_id = comment.id
WHERE parent_child_comment.parent_comment_id = 12

SELECT
  order_id,
  MAX(order_sum) AS d_sum
FROM table
GROUP BY order_id
HAVING COUNT(id) > 1

SELECT SUM(d_sum) AS a_sum
FROM (
  SELECT
    order_id,
    MAX(order_sum) AS d_sum
  FROM table
  GROUP BY order_id
  HAVING COUNT(id) > 1
) AS q

$('.stat_acc_block').html('<span class="stat_acc_block_text">Данные пользователя ' +
  $('td #2').html() + ' ' + $('td #3').html() + '</span>');

$('.stat_acc_block').html('<span class="stat_acc_block_text">Данные пользователя ' +
  $('td #2').val() + ' ' + $('td #3').val() + '</span>');

for i in range(len(array), -1, -1):
  if len(array[i]) <= 2:
    del array[i]

array = [array[i] for i in range(len(array)) if len(array[i]) >= 2]

$datetime = DateTime::createFromFormat('D, j M Y H:i:s O', 'Thu, 2 Apr 2020 18:52:56 +0000');