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 '' at line 1
select distinct p.products_image, p.products_model, p.unit_of_measure, p.qty_per_unit, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, NULL as final_price from products p left join manufacturers m using(manufacturers_id) , products_description pd, categories c, products_to_categories p2c where ('83-000,84-279,84-000,86-284,86-000,87-284,87-000,88-284,88-000,89-284,89-000,90-284,90-000,92-284,92-000,93-284,93-000,94-284,94-000,124-277,124-000,390-139,390-000,390-134,387-141,387-000,387-133,388-142,388-000,388-133,389-143,389-000,389-133,386-140,386-000,386-133,391-140,391-000,391-134,392-141,392-000,392-134,149-0,149-277,149-300,149-000,151-0,151-000,186-0,186-284,186-000,385-139,385-000,385-133,382-140,382-000,382-132,383-141,383-000,383-132,384-142,384-000,384-132,176-0,176-284,176-000,181-279,181-000,381-132,381-139,381-000,393-142,393-000,393-134,545-000,576-294,576-000,220-281,220-000,223-281,223-000,224-282,224-000,225-282,225-000,226-282,226-000,227-282,227-000,228-283,228-000,229-283,229-000,230-283,230-000,231-283,231-000,232-288,232-000,233-288,233-000,234-288,234-000,235-288,235-000,236-288,236-000,237-289,237-000,238-289,238-000,239-289,239-000,240-289,240-000,241-290,241-000,242-290,242-000,243-290,243-000,416-290,416-000,245-292,245-000,246-292,246-000,247-292,247-000,248-292,248-000,249-291,249-000,250-291,250-000,251-291,251-000,252-291,252-000,253-293,253-000,254-293,254-000,255-293,255-000,256-293,256-000,257-296,257-000,258-296,258-000,259-296,259-000,260-296,260-000,415-281,415-000,285-290,285-000,298-000,322-279,322-000,335-000,337-000,338-105,338-111,338-000,340-106,340-111,340-000,341-104,341-111,341-000,353-285,353-000,346-278,346-000,347-278,347-000,348-278,348-000,349-285,349-000,351-285,351-000,352-285,352-000,394-139,394-000,394-135,395-140,395-000,395-135,396-141,396-000,396-135,397-142,397-000,397-135,398-143,398-000,398-135,399-139,399-000,399-137,400-140,400-000,400-137,401-141,401-000,401-137,402-142,402-000,402-137,403-139,403-000,403-138,404-140,404-000,404-138,405-141,405-000,405-138,406-142,406-000,406-138,407-139,407-000,407-144,408-140,408-000,408-144,409-141,409-000,409-144,410-142,410-000,410-144,418-170,418-000,418-163,419-172,419-000,419-163,420-171,420-000,420-163,421-173,421-000,421-163,422-170,422-000,422-164,423-171,423-000,423-164,424-172,424-000,424-164,425-173,425-000,425-164,426-170,426-000,426-165,427-172,427-000,427-165,428-171,428-000,428-165,429-173,429-000,429-165,430-170,430-000,430-166,431-171,431-000,431-166,432-172,432-000,432-166,433-173,433-000,433-166,434-174,434-000,434-166,435-170,435-000,435-167,436-171,436-000,436-167,437-172,437-000,437-167,438-173,438-000,438-167,439-170,439-000,439-168,440-171,440-000,440-168,441-172,441-000,441-168,442-173,442-000,442-168,443-174,443-000,443-168,444-170,444-000,444-169,445-171,445-000,445-169,446-172,446-000,446-169,447-173,447-000,447-169,528-279,528-000,531-205,531-000,532-205,532-000,533-205,533-000,534-205,534-000,542-000,543-205,543-000,544-205,544-000,550-287,550-000,549-287,549-000,552-205,552-000,553-205,553-000,557-205,557-000,558-300,558-000,562-203,562-000,560-233,560-236,560-000,561-300,561-000,563-203,563-000,564-203,564-000,565-203,565-000,566-203,566-000,567-203,567-000,568-203,568-000,569-203,569-000,570-300,570-000,571-234,571-235,571-000,573-285,573-000,574-285,574-000,575-300,575-000,577-295,577-000,578-284,578-000,579-284,579-000,584-205,584-000,588-294,588-000,589-294,589-000,590-294,590-000,591-295,591-000,592-295,592-000,593-295,593-000,600-278,600-000,601-000,614-262,613-277,613-000,615-262,615-000,616-000,618-205,618-000,623-268,623-000,621-205,621-000,622-205,622-000,624-269,624-000,630-262,630-000,632-286,632-000,633-000,633-205,635-286,635-000,636-286,636-000,639-0,639-000,644-300,644-000,645-286,645-000,646-286,646-000,647-286,647-000,654-000,655-000,656-000,657-262,657-000,658-000,659-234,659-000,660-234,660-000,') NOT LIKE CONCAT('%', p.products_id, '-', c.categories_id, ',%') and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%package%' or p.products_model like '%package%' or m.manufacturers_name like '%package%' or pd.products_description like '%package%') ) order by
[TEP STOP]
|
