Bled w zapytaniu mysl z inner join, wywala przy opcjach kategorii Opcje

[daniofantasy]

mam takie zapytanko co leci do bazy i wybiera wszystkie rekordy (po id), ktore spelniaja kryteria zaawansowanych opcji produktu i gdzies tam sie zagniezdzil blad - ktos pomoze?

zapytanko SQL:

[SQL] pobierz, plaintext 
SELECT 
	SearchFilter.ProductID AS id 
FROM 
	SearchFilter 
INNER JOIN 
	products_to_features products_to_features0 
ON 
	SearchFilter.ProductID = products_to_features0.ProductsId 
WHERE 
	(
		(
			(
					products_to_features0.FeaturedId = "2" 
				OR 
					products_to_features0.FeaturedId = "394" 
				OR 
					products_to_features0.FeaturedId = "7898"
			) 
			AND 
			(
					products_to_features0.ValueId = "943" 
				OR 
					products_to_features0.ValueId = "1588" 
				OR 
					products_to_features0.ValueId = "2057" 
				OR 
					products_to_features0.ValueId = "2924" 
				OR 
					products_to_features0.ValueId = "3288" 
				OR 
					products_to_features0.ValueId = "3298" 
				OR 
					products_to_features0.ValueId = "3304" 
				OR 
					products_to_features0.ValueId = "42458" 
				OR 
					products_to_features0.ValueId = "202643" 
				OR 
					products_to_features0.ValueId = "13491" 
				OR 
					products_to_features0.ValueId = "252913"
			)
		)
	) 
 
INNER JOIN 
	products_to_features products_to_features1 
ON 
	SearchFilter.ProductID = products_to_features1.ProductsId 
WHERE 
	(
		(
			(
					products_to_features1.FeaturedId = "1"
			) 
			AND 
			(
					products_to_features1.ValueId = "1027" 
				OR 
					products_to_features1.ValueId = "1030" 
				OR 
					products_to_features1.ValueId = "1031"
			)
		)
	) 
AND 
	(
		(
				SearchFilter.price>=0 
			AND 
				SearchFilter.price<=299.99
		)
	)
[SQL] pobierz, plaintext 

Bkled z mysql:

[PHP] pobierz, plaintext 
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'inner join products_to_features products_to_features1 on SearchFilter.Produ' at line 46
[PHP] pobierz, plaintext 

z gory dzieki

[kartin]

Tak jak napisał Kishin, najpierw JOINy później wyłącznie jeden raz WHERE.

Aby uprościć zapytanie zamiast serii OR użyj IN, BETWEEN też się przyda.