ajankuv

select DISTINCT ps_customer.email, 'base' AS _website, ps_customer.firstname,
ps_customer.lastname, ps_customer.passwd AS password_hash, ps_customer.company,
ps_customer.birthday AS dob, ps_customer.date_add AS created_at, '1' AS group_id,
ps_address.address1 AS _address_street, ps_address.postcode AS _address_postcode, IFNULL(NULLIF(ps_address.phone, ''), 5555555555) AS telephone,
ps_address.city AS _address_city, IFNULL(NULLIF(ps_address.phone, ''), 5555555555) AS _address_telephone, 'US' AS country_id,
'1' AS website_id, ps_customer.firstname AS _address_firstname, ps_customer.lastname AS _address_lastname
from ps_customer
INNER JOIN ps_address ON ps_customer.id_customer=ps_address.id_customer
WHERE ps_customer.active=1
GROUP BY ps_customer.id_customer;

ajankuv

select ps_product.id_product AS 'sku', ps_product.upc, ps_product.price, ps_product.weight, ps_product.date_add AS 'created_at',
CONCAT('/img/p/',
        IF(CHAR_LENGTH(pi.id_image) >= 5,
            CONCAT(
                SUBSTRING(pi.id_image, -5, 1),
                '/'),
            ''),
        IF(CHAR_LENGTH(pi.id_image) >= 4, CONCAT(SUBSTRING(pi.id_image, -4, 1), '/'), ''),
        IF(CHAR_LENGTH(pi.id_image) >= 3, CONCAT(SUBSTRING(pi.id_image, -3, 1), '/'), ''),
        if(CHAR_LENGTH(pi.id_image) >= 2, CONCAT(SUBSTRING(pi.id_image, -2, 1), '/'), ''),