nozzy

SELECT A.*,
B.mobile
FROM users as A 
left join phones as B on B.login = A.login
WHERE ( A.cash BETWEEN 0 AND 79.99) AND A.tariff = '15';

select 
t1.email as parent_email,
t2.email as email,
t2.password as password
from my_table t1
left join (
	select
	parrent_id, 
	email,
	password
	from my_table
	where parrent_id is not null
) t2 on t2.parrent_id = t1.parrent_id
where t1.parrent_id is null
order by t1.email

public function getCategoryNames($product_id) {     
        $query = $this->db->query("SELECT *, dac.top
        FROM " . DB_PREFIX . "category_description cd
        LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p2c.category_id = cd.category_id)
LEFT JOIN " . DB_PREFIX . "de_av_category as dac ON (p2c.category_id = dac.category_id)
        WHERE p2c.product_id = '" . (int)$product_id . "'AND cd.language_id = '" . (int)$this->config->get('config_language_id') . "'");     
        return $query->rows;
    }

INSERT INTO wp_postmeta (POST_ID, META_KEY, META_VALUE)
SELECT * FROM (SELECT '3333', 'related_p', ' ') AS t1
WHERE NOT EXISTS (
    SELECT META_ID FROM wp_postmeta WHERE POST_ID='3333' AND META_KEY = 'related_p'
) LIMIT 1;

select
t1.id,
sum(t2.res) as sum_res
from users t1
inner join otvety t2 on t2.id_user = t1.id
inner join voprosy t3 on t3.id = t2.id_vopr
where t3.id_cat = 5
group by t1.id
order by sum_res

"SELECT tgid FROM accounts where tgid =" + message.from_user.id

c.execute('SELECT tgid FROM accounts where tgid =?', message.from_user.id)
temp =  c.fetchone()
if temp is None:
*Если нет в БД*
else:
*если есть в БД*