update catalog_product_entity_int<\/p>\n
set catalog_product_entity_int.value = 1<\/p>\n
where (catalog_product_entity_int.attribute_id = 97) and catalog_product_entity_int.entity_id = (<\/p>\n
select entity_id from (<\/p>\n
SELECT product.entity_id as entity_id FROM bitnami_magento.catalog_product_entity product<\/p>\n
inner join catalog_product_entity_decimal price on price.entity_id = product.entity_id and (price.attribute_id in (78))<\/p>\n
inner join catalog_product_entity_int status_t on (status_t.entity_id = product.entity_id) and (status_t.attribute_id=97)<\/p>\n
where (price.value > 5 and price.value <= 50)<\/p>\n
and (status_t.value = 2)<\/p>\n
) as c<\/p>\n
)<\/p>\n","protected":false},"excerpt":{"rendered":"
update catalog_product_entity_int set catalog_product_entity_int.value = 1 where (catalog_product_entity_int.attribute_id = 97) and catalog_product_entity_int.entity_id = ( select entity_id from ( SELECT product.entity_id as entity_id FROM bitnami_magento.catalog_product_entity product inner join catalog_product_entity_decimal price on price.entity_id = product.entity_id and (price.attribute_id in (78)) inner join catalog_product_entity_int status_t on (status_t.entity_id = product.entity_id) and (status_t.attribute_id=97) where (price.value > 5 and price.value <= 50) … <\/p>\n