Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT value
- FROM catalog_product_entity_varchar
- WHERE entity_id=(
- SELECT cpet.entity_id
- FROM catalog_product_entity_text cpet
- WHERE cpet.attribute_id=(
- SELECT attribute_id
- FROM eav_attribute
- WHERE attribute_code="normalized_sku"
- AND entity_type_id=(
- SELECT entity_type_id
- FROM eav_entity_type
- WHERE entity_type_code="catalog_product"
- LIMIT 1
- )
- LIMIT 1
- )
- AND cpet.value LIKE "31%"
- LIMIT 1
- )
- AND attribute_id=(
- SELECT attribute_id
- FROM eav_attribute
- WHERE attribute_code="url_key"
- AND entity_type_id=(
- SELECT entity_type_id
- FROM eav_entity_type
- WHERE entity_type_code="catalog_product"
- LIMIT 1
- )
- LIMIT 1
- )
- LIMIT 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement