nozzy

select 
distinct
t1.user_id
from table t1
left join 
 (select distinct 
  user_id 
  from table 
  where status_id <> 0
 ) t2 on t2.user_id = t1.user_id
where t1.status_id = 0
and t2.user_id is null

$result = mysql_query("SELECT * FROM uploads_images WHERE products_id='$id'",$link) or die(mysql_error());

SELECT s1.id AS sq_id, s1.name AS t1_name  
FROM `list` AS s1 
WHERE s1.name IN ("YYY", "XXX")

select
text_column 
from
your_table
where not text_column regexp '[A-Za-z0-9]';

select 
t1.property_reg_num, 
t1.property_owner_name_id 
from property_table t1
inner join
(
 select  
 property_reg_num, 
 property_owner_name_id,
 MIN(property_record_on_year) min_year
 from property_table
 group by property_reg_num, 
 property_owner_name_id
) t2 on t2.property_reg_num = t1.property_reg_num 
        and t2.property_owner_name_id = t1.property_owner_name_id
        and t1.property_record_on_year in (t2.min_year, t2.min_year+1, t2.min_year+2)
group by t1.property_reg_num, 
t1.property_owner_name_id

select
t3.id,
t3.Customer,
t3.weight,
t4.others
from
(
  select
  t1.id,
  t1.Customer,
  t2.weight
  from Order t1
  inner join 
  (
    select
    Order_id,
    sum(Weight) as weight
    from Order_position
    group by Order_id
  ) t2 on t2.Order_id = t1.id
) t3 
  inner join
  (
    select
    Order_id,
    sum(Price * Value) as others
    from Order_other
    group by Order_id
  ) t4 on t4.Order_id = t3.id

SELECT	
t1.cname, t1.cmail
FROM
(
	SELECT cname, cmail,
       @cmail_rank := IF(@current_cmail = cmail, @cmail_rank + 1, 1) AS cmail_rank,
       @current_cmail := cmail 
  FROM your_table
  ORDER BY cname, cmail
) t1
WHERE t1.cmail_rank = 1

global $wpdb;
  
$qry = "select  t1.*
		from wp_posts t1
		inner join
		(
		  select 
		  post_id
		  from wp_postmeta
		  where meta_key = 'close_date' and meta_value = '2016-03-29' 
		) t2 on t2.post_id = t1.ID";

$rows = $wpdb->get_results( $qry );

foreach( $rows as $row ) {
	...
}

update posts
set post_content = CONCAT('bla', post_content, 'bla-bla')
where post_type = 'your_post_type';

update your_table
set level = 2;

update your_table
set level = 1,
set auto_up = false
where auto_up = true;

select * from your_table
order by level, date_created;