Skip to content

Instantly share code, notes, and snippets.

@benytocarlo
Created June 23, 2015 18:19
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save benytocarlo/9a8182bd616c8472362e to your computer and use it in GitHub Desktop.
Listado de Usuarios en magento
SELECT DISTINCT ce.entity_id AS b, email, 'default_password', (
SELECT value
FROM customer_entity_varchar
WHERE attribute_id =7
AND customer_entity_varchar.entity_id = b
) AS l_name, (
SELECT value
FROM customer_entity_varchar
WHERE attribute_id =5
AND customer_entity_varchar.entity_id = b
) AS f_name, 1
FROM `customer_entity` AS ce
JOIN customer_entity_varchar AS cev ON ce.entity_id = cev.entity_id
WHERE 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment