Who ordered what in Magento webshop with a query on db?

Upwork «Magento» Upwork test
1
  • ДА
SELECT e.*, sfoi.*, sfoa.lastname, sfoa.email, sfoa.street, sfoa.postcode, sfoa.country_id
FROM sales_flat_order e
INNER JOIN sales_flat_order_item sfoi ON (e.entity_id=sfoi.order_id)
INNER JOIN sales_flat_order_address sfoa ON (e.entity_id=sfoa.parent_id)
WHERE date_format(e.created_at, ‘%Y’) LIKE ‘2015’
AND sfoi.parent_item_id IS NULL
AND sfoi.qty_ordered > 0;
  • НЕТ
SELECT e.*, sfoi.*, sfoa.lastname, sfoa.email, sfoa.street, sfoa.postcode, sfoa.country_id
FROM sales_flat_order e
INNER JOIN sales_flat_order_item sfoi ON (e.entity_id=sfoi.order_id)
INNER JOIN sales_flat_order_address sfoa off (e.entity_id=sfoa.parent_id)
WHERE date_format(e.created_at, ‘%Y’) LIKE ‘2015’
AND sfoi.parent_item_id IS NULL
AND sfoi.qty_ordered > 0;
  • НЕТ
SELECT e.*, sfoi.*, sfoa.lastname, sfoa.email, sfoa.street, sfoa.postcode, sfoa.country_id
FROM sales_flat_order e
INNER JOIN sales_flat_order_item sfoi ON (e.entity_id=sfoi.orders_id)
INNER JOIN sales_flat_order_address sfoa ON (e.customer_id=sfoa.customer_id)
WHERE date_format(e.created_at, ‘%Y’) LIKE ‘2015’
AND sfoi.parent_item_id IS NULL
AND sfoi.qty_ordered > 0;
  • All of the above

stackoverflow.com/questions/29946467