Query:
					------------
					
				SELECT
					`items`.`ItemID`
				FROM
					`items`
				LEFT JOIN
					`items_desc` ON `items_desc`.`ItemID` = `items`.`ItemID`
				LEFT JOIN
					`items_categories` ON `items_categories`.`ItemID` = `items`.`ItemID`
				LEFT JOIN
					`categories` ON `categories`.`CategoryID` = `items_categories`.`ItemCategoryID`
				LEFT JOIN
					`categories_desc` ON `categories_desc`.`CategoryID` = `items_categories`.`ItemCategoryID`
				WHERE
					`items`.`ItemIsActive`
				AND
				(
					
					`items_categories`.`ItemCategoryID` = 36
				
				)
				GROUP BY
					`items`.`ItemID`
				ORDER BY
					`items_desc`.`ItemName` ASC
				LIMIT
					-42, 21
			
					
					------------
					Error:
					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 '-42, 21' at line 26
				
For Men / Natural cosmetics / NatureForYou.shop - Natural cosmetics & BIO products e-shop in Malta!