use bitnami_magento;<\/p>\n\n\n\n
SELECT * FROM bitnami_magento.catalog_product_entity_varchar
where ( attribute_id = 73 ) — and (value = ”)
limit 10<\/p>\n\n\n\n
replace into bitnami_magento.catalog_product_entity_varchar (attribute_id, store_id, entity_id, value )
SELECT 181, 0, product.entity_id, left(concat(“https:\/\/www.amazon.com\/s?k=”, product.value),255)
FROM bitnami_magento.catalog_product_entity_varchar product
inner join catalog_product_entity_int status_t on ( status_t.entity_id = product.entity_id ) and ( status_t.attribute_id = 97 and status_t.value = 1 )
where (product.attribute_id=73) — and (value = ”) — 73 = product name<\/p>\n\n\n\n
SELECT * FROM bitnami_magento.catalog_product_entity_varchar
where ( attribute_id = 181 ) — and (value = ”)
order by value_id desc
limit 10<\/p>\n\n\n\n
— Update Uk Urls —–<\/p>\n\n\n\n
use bitnami_magento;<\/p>\n\n\n\n
SELECT * FROM bitnami_magento.catalog_product_entity_varchar
where ( attribute_id = 73 ) — and (value = ”)
limit 10<\/p>\n\n\n\n
replace into bitnami_magento.catalog_product_entity_varchar (attribute_id, store_id, entity_id, value )
SELECT 180, 0, product.entity_id, left(concat(“https:\/\/www.amazon.co.uk\/s?k=”, product.value), 255)
FROM bitnami_magento.catalog_product_entity_varchar product
inner join catalog_product_entity_int status_t on ( status_t.entity_id = product.entity_id ) and ( status_t.attribute_id = 97 and status_t.value = 1 )
where (product.attribute_id=73) — and (value = ”) — 73 = product name<\/p>\n\n\n\n
SELECT * FROM bitnami_magento.catalog_product_entity_varchar
where ( attribute_id = 180 ) — and (value = ”)
order by value_id desc
limit 10<\/p>\n\n\n\n