Note: Third-party libraries and minified JS/CSS files are excluded from these statistics where
possible, so the numbers you see here may be lower than those reported by other tools.
Things that the plugin adds to the site. This section is not intended to be comprehensive.
The test tool only looks for a few specific types of added content.
[13-Jan-2023 23:17:15 UTC] WordPress database error Table 'wordpress.wp_lasso_url_details' doesn't exist for query
SELECT COUNT(*) AS `count`
FROM (
SELECT BASE.import_source
FROM
(
SELECT
p.id,
p.post_type,
CASE
WHEN p.post_type = 'pretty-link'
THEN 'Pretty Links'
WHEN p.post_type = 'thirstylink'
THEN 'Thirsty Affiliates'
WHEN p.post_type = 'earnist'
THEN 'Earnist'
WHEN p.post_type = 'affiliate_url'
THEN 'Affiliate URLs'
WHEN p.post_type = 'aawp'
THEN 'AAWP'
WHEN p.post_type = 'easyazon'
THEN 'EasyAzon'
WHEN p.post_type = 'amalinks'
THEN 'Amalinks Pro'
WHEN p.post_type = 'lasso-urls'
THEN 'Lasso Pro'
ELSE 'Unknown'
END AS import_source,
CONVERT(p.post_name USING utf8) as post_name,
CONVERT(p.post_title USING utf8) AS post_title,
'' AS check_status,
'' AS check_disabled
FROM wp_posts AS p
WHERE
post_type IN ('pretty-link', 'earnist')
AND p.ID NOT IN (
SELECT post_id
FROM wp_postmeta
WHERE meta_key = 'old_status'
AND meta_value != ''
)
AND post_status IN ('publish', 'pending', 'draft', 'future', 'private', 'inherit', 'trash')
UNION
SELECT DISTINCT
CONVERT(substring_index( substring_index(option_name, 'easyazon_item_', -1), '_', 1) USING utf8) AS id,
'easyazon' AS post_type,
'EasyAzon' AS import_source,
'' AS post_name,
CONVERT(substring_index( option_name, '_', 4) USING utf8) AS post_title,
CASE
WHEN CONVERT(substring_index( substring_index(option_name, 'easyazon_item_', -1), '_', 1) USING utf8) IN (
SELECT CONVERT(old_uri USING utf8) AS old_uri
FROM wp_lasso_lite_revert
WHERE plugin = 'easyazon'
)
THEN 'checked'
ELSE ''
END AS check_status,
'' AS check_disabled
FROM wp_options AS ap
WHERE option_name LIKE 'easyazon_item_%'
UNION
SELECT
po.ID as id,
po.post_type,
'Easy Affiliate Links' as import_source,
CONVERT(po.post_name USING utf8) as post_name,
CONVERT(po.post_title USING utf8) as post_title,
'' as check_status,
'' as check_disabled
FROM wp_posts as po
INNER JOIN wp_postmeta as pom ON po.ID = pom.post_id
WHERE po.post_type = 'easy_affiliate_link'
AND pom.meta_value = 'text'
UNION
SELECT
po.ID AS id,
po.post_type,
'Affiliate URLs' AS import_source,
CONVERT(po.post_name USING utf8) AS post_name,
CONVERT(po.post_title USING utf8) AS post_title,
'' AS check_status,
'' AS check_disabled
FROM wp_posts AS po
INNER JOIN wp_postmeta AS pom
ON po.ID = pom.post_id
WHERE po.post_type = 'affiliate_url'
AND pom.meta_key = '_affiliate_url_redirect'
AND pom.meta_value IS NOT NULL
AND pom.meta_value <> ""
UNION
(+1400 more lines)
