SmartCJ Support Forum

Code: Select all

<?php
require('../includes/prepare.php');

db_query("UPDATE rot_thumbs SET thumb_status = 'to_delete' 
WHERE thumb_id IN (
SELECT rot_gallery_stats1.thumb_id
FROM rot_gallery_stats1
LEFT JOIN rot_gallery_info on rot_gallery_stats1.gallery_id = rot_gallery_info.gallery_id 
WHERE total_shows >= '500'
AND total_ctr <= '0.1' 
AND rot_gallery_info.gallery_type = 0
AND rot_gallery_info.sponsor_id IN (1,2,3)
AND rot_gallery_stats1.group_id IN (4,5,6)
)");