Hi,
I have 1 product, productnr => 29795
This product has 7 combinations color.
What i want is a query thats include the name, description, price, modifer prijs, color, so all other details
How can i combine these 2 queries?
Does anyone know the query?
Query Prodcucts:
Select
cscart_product_descriptions.product,
cscart_product_prices.price,
cscart_product_option_variants.modifier,
cscart_product_descriptions.full_description,
cscart_product_option_variants_descriptions.variant_name,
cscart_product_options.product_id,
cscart_product_options_descriptions.option_text
From
cscart_product_options Left Join
cscart_product_option_variants On cscart_product_option_variants.option_id =
cscart_product_options.option_id Left Join
cscart_product_option_variants_descriptions
On cscart_product_option_variants_descriptions.variant_id =
cscart_product_option_variants.variant_id Left Join
cscart_product_descriptions On cscart_product_options.product_id =
cscart_product_descriptions.product_id Inner Join
cscart_product_prices On cscart_product_prices.product_id =
cscart_product_descriptions.product_id Inner Join
cscart_product_options_descriptions On cscart_product_options.option_id =
cscart_product_options_descriptions.option_id
Where
cscart_product_options.product_id = 29795 And
cscart_product_option_variants_descriptions.lang_code = 'NL' And
cscart_product_descriptions.lang_code = 'NL' And
cscart_product_options_descriptions.lang_code = 'NL'
Output Products:
Toy 125 0 lorem ipsum descrip Zwart antraciet 29795 Kleur
Toy 125 0 lorem ipsum descrip Wit 29795 Kleur
Toy 125 0 lorem ipsum descrip Grijs 29795 Kleur
Toy 125 0 lorem ipsum descrip Oranje 29795 Kleur
Toy 125 0 lorem ipsum descrip Rood 29795 Kleur
Toy 125 0 lorem ipsum descrip Bruin 29795 Kleur
Query Images:
Select
*
From
cscart_images_links Inner Join
cscart_images On cscart_images.image_id = cscart_images_links.detailed_id
Where cscart_images_links.object_id = 29795
Output Images:
5654 29795 product 0 8134 A 8134 Toy_rood.jpg 500 500
5653 29795 product 0 8133 A 8133 Toy_grijs135825577450f5569e5e1d2.jpg 500 500
5652 29795 product 0 8132 A 8132 Toy_wit135825586650f556fa9e808.jpg 500 500
5651 29795 product 0 8131 A 8131 Toy_zwart.jpg 500 500
5656 29795 product 0 8136 A 8136 Toy_bruin.jpg 500 500
6416 29795 product 0 8989 A 8989 Toy_oranje135825574350f5567fc9cac.jpg 500 500
4578 29795 product 0 7015 M 7015 Toy_zwart.jpg 500 500
use Union