Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT name FROM products WHERE art_nr=(SELECT fits_artnr1 FROM accessories_association JOIN products ON products.art_nr=accessories_association.art_nr WHERE products.id ='" + activeProductId + "') OR art_nr=(SELECT fits_artnr2 FROM accessories_association JOIN products ON products.art_nr=accessories_association.art_nr WHERE products.id ='" + activeProductId + "') OR art_nr=(SELECT fits_artnr3 FROM accessories_association JOIN products ON products.art_nr=accessories_association.art_nr WHERE products.id ='" + activeProductId + "') OR art_nr=(SELECT fits_artnr4 FROM accessories_association JOIN products ON products.art_nr=accessories_association.art_nr WHERE products.id ='" + activeProductId + "') OR art_nr=(SELECT fits_artnr5 FROM accessories_association JOIN products ON products.art_nr=accessories_association.art_nr WHERE products.id ='" + activeProductId + "') OR art_nr=(SELECT fits_artnr6 FROM accessories_association JOIN products ON products.art_nr=accessories_association.art_nr WHERE products.id ='" + activeProductId + "') OR art_nr=(SELECT fits_artnr7 FROM accessories_association JOIN products ON products.art_nr=accessories_association.art_nr WHERE products.id ='" + activeProductId + "')"
Add Comment
Please, Sign In to add comment