anton-roos

/* Delete all bounced email addresses from list 13 */
DELETE FROM `subscribers` WHERE `bounced` = 1 AND `list` = 13;

/* Delete all marked as spam email addresses from list 5 */
DELETE FROM `subscribers` WHERE `complaint` = 1 AND `list` = 5;

anton-roos

<script>
  document.write(new Date().getFullYear())
</script>

anton-roos

UPDATE  `wp_cf7dbplugin_submits`
SET  `field_name` = REPLACE(`field_name`, 'tel-123', 'tel-576')
WHERE  `field_name` LIKE 'tel-123%';

anton-roos

UPDATE `wp_postmeta`
SET `meta_value` = 'yes'
WHERE `meta_key` = '_manage_stock'

anton-roos

UPDATE `wp_postmeta`
SET `meta_value` = 'no'
WHERE `meta_key` = '_sold_individually'

anton-roos

SELECT meta_value
FROM wp_postmeta
WHERE meta_key = '_sku'
AND meta_value != ''
GROUP BY meta_value HAVING COUNT(meta_value) > 1

anton-roos

SELECT `meta_value`, `meta_key`, count(*) 
FROM wp_postmeta WHERE meta_key LIKE '_sku'  
GROUP BY `meta_value`  
ORDER BY `count(*)`  DESC

anton-roos

SELECT ID
FROM `wp_posts`
WHERE ID 
NOT IN (select `post_id` from `wp_postmeta` WHERE `meta_key`="_thumbnail_id") 
AND `post_type`="product"

anton-roos

UPDATE wp_postmeta
SET `meta_value` = 'outofstock'
WHERE `meta_value` = 'instock'
AND `meta_key` = '_stock_status'

anton-roos

git pull
echo "Git pull done, fetching timetable..."
for branch
in `git branch -r | grep -v HEAD`;do echo -e `git show --format="%ci %cr" $branch | head -n 1` \\t$branch;
done | sort -r