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

Po co tam robisz taki zmasowany atak nawiasów to nawet nie pytam ale,
robisz joina po wherze przez co wywala błąd.

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.

Zły dział, przenoszę.