Алекс Иванов

Use of ORDER BY for individual SELECT statements implies nothing about the order in which the rows appear in the final result

select /*payload*/ from user
where rank_golos >0
order by rank_golos >=22.1 desc, 
  if (rank_golos >=22.1, rank_yearnub, rank_golos) desc,
  if (rank_golos >=22.1, rank_golos, rank_yearnub) desc

SELECT * 
FROM `abitura` 
WHERE abitura.bal>5 
AND NOT EXISTS (SELECT * FROM `proverka` WHERE abitura.id=proverka.userid AND proverka.proveril=$pr )
ORDER BY RAND() limit 0,10

SELECT `group`, `user`, `userid`, 2, 'tester', 1 FROM ...

document.addEventListener("DOMContentLoaded", function() {
	document.querySelector("#my_input").value = ""
})

$string = 'dd  dss рис. 69 ddd';
$pattern = '~(рис\. (\d+))~';
$replacement = '<a href="#pict$2">$1</a>';
echo preg_replace($pattern, $replacement, $string);

SELECT * from posts whete title IN  (<?= implode($array, ','); ?>);

SELECT * FROM `posts` WHERE `title` IN ('$var1', '$var2', '$var3')