SELECT
    entity_id
FROM
    catalog_product_entity_text
WHERE
    value LIKE "%not%re%manufacture%"
    AND attribute_id != 144
GROUP BY
    entity_id;

SELECT
    entity_id
FROM
    catalog_product_entity_text
WHERE
    value LIKE "%not%re%buil%"
    AND attribute_id != 144
GROUP BY
    entity_id;

SELECT
    entity_id
FROM
    catalog_product_entity_text
WHERE
    value LIKE "%re-manufacture%"
    AND attribute_id != 144
GROUP BY
    entity_id;

SELECT
    entity_id
FROM
    catalog_product_entity_text
WHERE
    value LIKE "%re-buil%"
    AND attribute_id != 144
GROUP BY
    entity_id;

SELECT
    *
FROM
    catalog_product_entity_text
WHERE
    value LIKE "%.com%"
    AND attribute_id != 169
LIMIT
    1000;


    

SELECT
    catalog_product_entity_text.entity_id,
    catalog_product_entity.sku
FROM
    catalog_product_entity_text
    LEFT JOIN catalog_product_entity ON catalog_product_entity.entity_id = catalog_product_entity_text.entity_id
    LEFT JOIN xlentparts_ebaystoremanager_activelisting ON xlentparts_ebaystoremanager_activelisting.sku = catalog_product_entity.sku
WHERE
    xlentparts_ebaystoremanager_activelisting.item_id IS NOT NULL
    AND (
        catalog_product_entity_text.value LIKE "%warranty%"
        OR catalog_product_entity_text.value LIKE "%bulk%delivery%"
        OR catalog_product_entity_text.value LIKE "%customer%"
        OR catalog_product_entity_text.value LIKE "%_x000D_%"
        OR catalog_product_entity_text.value LIKE "%N/A%"
        OR catalog_product_entity_text.value LIKE "%Cancer%"
        OR catalog_product_entity_text.value LIKE "%P65%"
        OR catalog_product_entity_text.value LIKE "%GTIN%"
        OR catalog_product_entity_text.value LIKE "%.com%"
        OR catalog_product_entity_text.value LIKE "%fit%"
    )
    AND catalog_product_entity_text.attribute_id IN (75, 76, 172, 186)
GROUP BY
    entity_id;


eBay Product Title Builder