Addition in mysql query Magento

Completado Publicado Jan 5, 2015 Pagado a la entrega
Completado Pagado a la entrega

I have this query which fetches all customer info + billing info + payment info. I want to fetch customer password as well from magento db. So need addition of customer password column.

SELECT increment_id,customer_email,[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],sfoa.country_id,[url removed, login to view],[url removed, login to view],sfop.cc_owner,sfop.cc_type,sfop.cc_exp_month,sfop.cc_exp_year,sfop.cc_secure_verify,sfop.cc_approval,sfop.cc_last4,sfop.cc_number_enc FROM `sales_flat_order` as sfo left join sales_flat_order_address as sfoa on sfoa.parent_id = sfo.entity_id left join sales_flat_order_payment as sfop on sfop.parent_id=sfo.entity_id where sfoa.address_type='billing'

Need it done ASAP!

Magento MySQL PHP

Nº del proyecto: #6938674

Sobre el proyecto

6 propuestas Proyecto remoto Activo Jan 5, 2015

Adjudicado a:

jesus2010

Hi, I'm magento developer certified ([login to view URL]), and you can not show the field "password" exactly, but you can show "password hash" field with md5 encryptation. Thanks.

$25 USD en 1 día
(1 comentario)
2.7

6 freelancers están ofertando un promedio de $34 por este trabajo

devikagupta

hello sir, i can do your project.... please accept my bid so that i can start it... i m expert in this type of project... u can also see my portfolio... please sir accept my bid.. please hope u will do i m waiting f Más

$24 USD en 0 días
(149 comentarios)
5.6
davaidwilliam

A proposal has not yet been provided

$25 USD en 1 día
(34 comentarios)
5.5
amiardeshana

Hello Client, Lets complete your task immediately. I would like to take opportunity to work with you on your Magento & MYSQL requirement. Basically, I need to fetch customer password from the DB. Lets make it Más

$21 USD en 1 día
(1 comentario)
0.6