Working query (for admin):
SELECT commerce_product_field_data_field_product.product_id AS commerce_product_field_data_field_product_product_id, commerce_product_field_data_field_product.title AS commerce_product_field_data_field_product_title, commerce_product_field_data_field_product__field_data_commerce_price.commerce_price_amount AS commerce_product_field_data_field_product__field_data_commer, 'commerce_product' AS field_data_field_image_commerce_product_entity_type, 'commerce_product' AS field_data_commerce_price_commerce_product_entity_type FROM node node LEFT JOIN votingapi_cache votingapi_cache_node_points_vote_average ON node.nid = votingapi_cache_node_points_vote_average.entity_id AND (votingapi_cache_node_points_vote_average.entity_type = :views_join_condition_0 AND votingapi_cache_node_points_vote_average.value_type = :views_join_condition_1 AND votingapi_cache_node_points_vote_average.tag = :views_join_condition_2 AND votingapi_cache_node_points_vote_average.function = :views_join_condition_3) LEFT JOIN field_data_field_product field_data_field_product ON node.nid = field_data_field_product.entity_id AND (field_data_field_product.entity_type = :views_join_condition_4 AND field_data_field_product.deleted = :views_join_condition_5) LEFT JOIN commerce_product commerce_product_field_data_field_product ON field_data_field_product.field_product_product_id = commerce_product_field_data_field_product.product_id LEFT JOIN field_data_field_product commerce_product_field_data_field_product__field_data_field_product ON commerce_product_field_data_field_product.product_id = commerce_product_field_data_field_product__field_data_field_product.field_product_product_id AND commerce_product_field_data_field_product__field_data_field_product.deleted = :views_join_condition_6 LEFT JOIN node node_field_data_field_product ON commerce_product_field_data_field_product__field_data_field_product.entity_id = node_field_data_field_product.nid LEFT JOIN field_data_commerce_price commerce_product_field_data_field_product__field_data_commerce_price ON commerce_product_field_data_field_product.product_id = commerce_product_field_data_field_product__field_data_commerce_price.entity_id AND (commerce_product_field_data_field_product__field_data_commerce_price.entity_type = :views_join_condition_7 AND commerce_product_field_data_field_product__field_data_commerce_price.deleted = :views_join_condition_8) WHERE (( (node.status = :db_condition_placeholder_9) AND (node.type IN (:db_condition_placeholder_10)) )) ORDER BY commerce_product_field_data_field_product_title ASC, commerce_product_field_data_field_product__field_data_commer ASC LIMIT 12 OFFSET 0


non-working query (anonymous users)
SELECT commerce_product_field_data_field_product.product_id AS commerce_product_field_data_field_product_product_id, commerce_product_field_data_field_product.title AS commerce_product_field_data_field_product_title, commerce_product_field_data_field_product__field_data_commerce_price.commerce_price_amount AS commerce_product_field_data_field_product__field_data_commer, 'commerce_product' AS field_data_field_image_commerce_product_entity_type, 'commerce_product' AS field_data_commerce_price_commerce_product_entity_type FROM {node} node LEFT JOIN {votingapi_cache} votingapi_cache_node_points_vote_average ON node.nid = votingapi_cache_node_points_vote_average.entity_id AND (votingapi_cache_node_points_vote_average.entity_type = 'node' AND votingapi_cache_node_points_vote_average.value_type = 'points' AND votingapi_cache_node_points_vote_average.tag = 'vote' AND votingapi_cache_node_points_vote_average.function = 'average') LEFT JOIN {field_data_field_product} field_data_field_product ON node.nid = field_data_field_product.entity_id AND (field_data_field_product.entity_type = 'node' AND field_data_field_product.deleted = '0') LEFT JOIN {commerce_product} commerce_product_field_data_field_product ON field_data_field_product.field_product_product_id = commerce_product_field_data_field_product.product_id LEFT JOIN {field_data_field_product} commerce_product_field_data_field_product__field_data_field_product ON commerce_product_field_data_field_product.product_id = commerce_product_field_data_field_product__field_data_field_product.field_product_product_id AND commerce_product_field_data_field_product__field_data_field_product.deleted = '0' LEFT JOIN {node} node_field_data_field_product ON commerce_product_field_data_field_product__field_data_field_product.entity_id = node_field_data_field_product.nid LEFT JOIN {field_data_commerce_price} commerce_product_field_data_field_product__field_data_commerce_price ON commerce_product_field_data_field_product.product_id = commerce_product_field_data_field_product__field_data_commerce_price.entity_id AND (commerce_product_field_data_field_product__field_data_commerce_price.entity_type = 'commerce_product' AND commerce_product_field_data_field_product__field_data_commerce_price.deleted = '0') WHERE (( (node.status = '1') AND (node.type IN  ('product_display')) )) ORDER BY commerce_product_field_data_field_product_title ASC, commerce_product_field_data_field_product__field_data_commer ASC LIMIT 12 OFFSET 0