Select osCommerce customers subscribed after date X [crayon lang=»mysql»] SELECT c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_email_address, ci.customers_info_date_account_created FROM customers c, customers_info ci WHERE c.customers_id = ci.customers_info_id AND ci.customers_info_date_account_created > ‹2010-11-05 00:00:00›; [/crayon] Select osCommerce customers subscribed to newsletter [crayon lang=»mysql»] SELECT `customers_gender`, `customers_lastname`, `customers_email_address` FROM `customers` WHERE `customers_newsletter` = 1;[/crayon] Select osCommerce customers und address_book [crayon lang=»mysql»] […]
