SELECT * FROM production, brand, category, image WHERE production.brandID = brand.brandID AND production.categoryID = category.categoryID AND (production.productionID = image.productionID AND image.imagePosition = 1) AND productionURI = login;

Неправильный запрос