idShura

select case when a.position = 0 
            then 0 
            else a.position +1
        end position
  from (SELECT COUNT(*) AS `position` 
          FROM `season_" + season + "` 
         WHERE `RATING` > ( SELECT `RATING` 
                              FROM `season_" + season + "` 
                             WHERE `ID`= '" + id + "' LIMIT 1 )
    ) as a

SELECT distinct REGEXP_SUBSTR(str, '(?<=\\|\\s)_.*(?=\\s\\+)') FROM TABLE WHERE ...

select t1.*, t2.* 
  from modx_site_content t1
       left join modx_ms2_products t2 on t2.id = t1.id
 where t1.id = 541

BEGIN;
	DELETE FROM table_1 WHERE ID = 80; 
	DELETE FROM table_2 WHERE ID = 80;
COMMIT;

select pd.product_id, 
        pd.name 
        pa.price
   from product_description  pd
        left join product_article pa on pa.product_id = pd.product_id

select t1.id,
       t1.model,
       t2.category,
       t2.main_category
  from table1 t1
       left join table2 t2 on t2.id = t1.id
 where t2.main_category = 1