(03) 9783 3775 or 1300 558467    21 Rosella Street, Frankston Victoria
Brushes & Combs

Brushes & Combs

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where c.categories_id not in(507, 508, 509) and p.products_id not in(7976, 7962,' at line 17

select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, pd.products_description, p.products_date_available, p.products_price, if(s.status, s.specials_new_products_price, null) as specials_new_products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '437' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added desc limit 9 where c.categories_id not in(507, 508, 509) and p.products_id not in(7976, 7962, 8759, 8874, 8916, 8933, 8934, 7648, 3596, 7086, 3754, 3756, 3757, 3758, 3759, 3762, 3763, 3764, 3765, 3766, 3770, 3772, 3773, 3774, 3775, 3776, 3778, 3779, 3781, 3782, 3783, 3785, 3788, 3789, 3790, 3791, 3792, 3793, 3794, 3795, 3807, 3808, 3809, 3811, 3812, 3813, 3815, 3816, 3819, 3822, 3823, 3826, 3828, 3829, 3831, 3832, 3833, 3834, 3835, 3836, 3838, 3839, 3840, 3841, 3842, 3843, 3844, 3845, 3847, 3849, 3850, 3851, 3852, 3856, 3860, 3876, 3887, 3890, 3893, 3895, 3896, 3897, 3898, 3899, 3900, 7901, 7902, 7903, 7904, 7905, 7906, 7907, 7908, 7909, 7910, 7911, 7912, 7913, 7914, 7915, 7916, 7917, 7918, 7919, 7920, 7921, 7923, 7924, 7925, 7927, 7930, 7931, 7932, 7933, 7934, 7935, 7936, 7937, 7938, 7939, 7941, 7942, 7943, 7944, 7945, 7946, 7947, 7948, 7949, 7950, 7951, 7952, 7953, 7954, 7955, 7956, 7957, 7958, 7959, 7960, 7961, 7963, 7964, 7965, 7966, 7967, 7968, 7969, 7970, 7971, 7972, 7973, 7974, 7975, 7977, 7978, 7979, 7980, 7981, 7982, 7983, 7984, 7985, 7986, 7987, 7988, 7989, 7990, 7991, 7992, 7993, 7994, 7995, 7996, 7998, 7999, 8000, 8001, 8002, 8003, 8004, 8005, 8006, 8007, 8008, 8009, 8010, 8011, 8013, 8014, 8015, 8016, 8017, 8018, 8019, 8020, 8021, 8022, 8023, 8024, 8025, 8026, 8027, 8028, 8029, 8030, 8031, 8032, 8033, 8034, 8035, 8036, 8037, 8038, 8039, 8040, 8041, 8042, 8043, 8044, 8045, 8046, 8047, 8048, 8049, 8050, 8051, 8052, 8054, 8055, 8056, 8057, 8058, 8059, 8060, 8061, 8062, 8063, 8064, 8065, 8066, 8067, 8068, 8873, 8875, 8876, 8877, 8878, 8879, 8880, 8881, 8882, 8883, 8884, 8885, 8886, 8887, 8888, 8889, 8890, 8891, 8892, 8893, 8894, 8895, 8896, 8897, 8898, 8899, 8900, 8901, 8902, 8903, 8904, 8905, 8906, 8907, 8908, 8909, 8910, 8911, 8912, 8913, 8914)

[TEP STOP]