SELECT
DISTINCT product_option_value.product_id,
product.id AS productt_id,
product.lang1
FROM product_option_value
LEFT JOIN product ON product_option_value.product_id = product.id
LIMIT 2




SELECT
DISTINCT
t1.product_id,
t1.prod_option_id,
t1.prod_option_item_id,
t2.lang1,
t3.lang1
FROM product_option_value AS t1
LEFT JOIN product AS t2 ON t1.product_id = t2.id
LEFT JOIN prod_option AS t3 ON t3.id = t1.prod_option_id




SELECT
DISTINCT
t1.product_id,
t1.prod_option_id,
t1.prod_option_item_id,
t2.lang1
FROM product_option_value AS t1
LEFT JOIN product AS t2 ON t1.product_id = t2.id

SELECT
DISTINCT
product_option_value.product_id,
product_option_value.prod_option_id,
product_option_value.prod_option_item_id,
product.lang1
FROM product_option_value
LEFT JOIN product ON product_option_value.product_id = product.id


SELECT t1.id AS t1id, t2.* FROM `product` AS t1 LEFT JOIN product_option_value AS t2 ON t1.id = t2.product_id

SELECT t2.* FROM `product_option_value` AS t1 LEFT JOIN product AS t2 ON t1.product_id = t2.id


SELECT DISTINCT t2.* FROM `product_option_value` AS t1 LEFT JOIN product AS t2 ON t1.product_id = t2.id LIMIT 2


SELECT
t1.*,
t2.*,
t3.*,
t4.*
FROM `product_option_value` AS t1
JOIN product_option_value AS t2 ON t1.product_id = t2.product_id
JOIN product_option_value AS t3 ON t1.product_id = t3.product_id
JOIN product AS t4 ON t1.product_id = t4.id
WHERE
t1.product_id = t2.product_id AND
t2.product_id = t3.product_id AND
(t1.`prod_option_id` = 1 AND t1.prod_option_item_id = 19) AND
(t2.`prod_option_id` = 2 AND t2.prod_option_item_id = 23) AND
(t3.`prod_option_id` = 3 AND t3.prod_option_item_id = 26)


SELECT
t1.*,
t2.*,
t3.*
FROM `product_option_value` AS t1
JOIN `product_option_value` AS t2 ON t1.product_id = t2.product_id AND t2.id NOT IN (t1.id)
JOIN `product_option_value` AS t3 ON t1.product_id = t3.product_id AND t3.id NOT IN (t1.id,t2.id)


SELECT
t1.*,
t2.*,
t3.*
FROM `product_option_value` AS t1
JOIN `product_option_value` AS t2
JOIN `product_option_value` AS t3

WHERE
t1.product_id = t2.product_id AND
t1.product_id = t3.product_id AND
(t1.prod_option_id = 1 AND t1.prod_option_item_id = 19) AND
(t2.prod_option_id = 2 AND t2.prod_option_item_id = 23) AND
(t3.prod_option_id = 3 AND t3.prod_option_item_id = 26);


SELECT DISTINCT product.* FROM product
CROSS JOIN product_option_value AS brands ON product.id = brands.product_id
CROSS JOIN product_option_value AS colors ON product.id = colors.product_id
CROSS JOIN product_option_value AS sizes ON product.id = sizes.product_id

WHERE
(brands.prod_option_id = 1 AND brands.prod_option_item_id = 19) AND
(colors.prod_option_id = 2 AND colors.prod_option_item_id = 23) AND
(sizes.prod_option_id = 3 AND sizes.prod_option_item_id = 26)