// --- unikaalu ierakstu skaits
"SELECT COUNT(DISTINCT ip) as tot_ip FROM user_log"

// --- kopeejam datus no vienas tab uz otru
insert
into table2
( col1
, col2
, col3 )
select 
field3
, ( field7 + field8 ) * 9.37
, 0
from table1

// --- kopeejam ierakstus tajaa pashaa tabulaa
INSERT INTO web_content
SELECT '' as id,'de' as lang,asoc,title,keywords,description,content,add_m,add_var,0 as count
FROM web_content 
WHERE lang = 'lv';

// --- apreekjinam vecumu
SELECT DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(dob, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(dob, '00-%m-%d')) AS age

// --- ieguustam starpiibu
SELECT TIMESTAMPDIFF(DAY, '1980-05-15', NOW()) as dif;
SELECT TIMESTAMPDIFF(YEAR, '1980-05-15', NOW()) as dif;

// --- mekleejam peec simbola noteiktaa poziicijaa
SELECT word FROM table WHERE SUBSTRING(word,1,1) = 's'

// --- mekleejam peec simbola noteiktaa poziicijaa + garums
SELECT word FROM table
WHERE
SUBSTRING(word,1,1) = 's'
AND
SUBSTRING(word,4,1) = 'a'
AND
CHAR_LENGTH(word) = 5

// --- unix funkcijas
UNIX_TIMESTAMP()
UNIX_TIMESTAMP('2005-03-27 02:00:00')]
 
// ---- ieguustam starpiibu
SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(last) as dif FROM arb_user_time

// ---------------------------------------------------------- SQLs
$sql = "SELECT WEEKOFYEAR(created) as wofy,count(id) as cnt FROM g_user_log WHERE user_id IN(".$user_id_str.") AND DATE_SUB(CURDATE(),INTERVAL 3 MONTH) <= created GROUP BY WEEKOFYEAR(created)";