Witam, pracuje wlasnie nad skryptem ktory będę uzywac na webcronie. Mam 2 query ktore chce polaczyc separatorem, ale mi to nie wychodzi, macie może pomysł jak to mozna polaczyć? Z góry dziekuje za pomoc.
DELETE a FROM wp_posts
AS a INNER
JOIN ( SELECT post_content
, MIN( id
) AS min_id FROM wp_posts WHERE post_type
= 'post' AND post_status
= 'publish' GROUP BY post_content HAVING
COUNT( * ) > 1
) AS b ON b
.post_content
= a
.post_content AND b
.min_id
<> a
.id AND a
.post_type
= 'post' AND a
.post_status
= 'publish';
DELETE FROM wp_posts
WHERE post_content NOT LIKE '%<img src=%'AND ID not in (select post_id as p from wp_postmeta where meta_key like '_wp_attached_file')
OR `post_title` like '%.png%'
OR post_date < DATE_SUB(NOW(), INTERVAL 15 day);