SELECT parent_block, parent_sub, category_id, category_name_db, category_td_by_des_id, category_td, category_td_add, parent_block_name FROM a1_categories JOIN a1_categories_parent_block ON (a1_categories_parent_block.parent_block_id = a1_categories.parent_block) WHERE status='1' AND category_id NOT IN ('328222', '329222','323') AND category_td IN ('100010', '100042', '100041', '100350', '100014', '100071', '100002', '100245', '100470', '100005', '100259', '100019', '100597', '100383', '100384', '100260', '100012', '100601', '100603', '100198', '100006', '100626', '100032', '100013', '100206', '100579', '100035', '100322', '100555', '100339', '100693', '100011', '100113', '100074', '100001', '101690', '101700', '101703', '101705', '101745', '101752', '100826', '100341', '102697', '100733', '100862', '100535', '100538', '100208', '100572', '100004', '100222', '100317', '100325', '100026', '100018', '100133', '104302', '104308', '104311', '100016', '100082', '100434', '104312', '100435', '100007', '100094', '100095', '100030', '100598', '100027', '100807', '100262', '100591', '100199', '100263', '100241', '100346', '100594', '101648', '101673', '101777', '104314', '100441', '100475', '100491', '100578', '102747', '100213', '103099', '103102', '100008', '100151', '100754', '100478', '100334', '100553', '100249', '101696', '101760', '101780', '101763', '100743', '100181', '100165', '100216', '100088', '100091', '104956', '100210', '100596', '100627', '102964', '100034', '100400', '100703', '100707', '100806', '100352', '100834', '103479', '100211', '100581', '100370', '100381', '100372', '100735', '100062', '100121', '100238', '706233', '101994', '101996', '100590', '100577', '102203', '102205', '100050', '104813', '102208', '100239', '100769', '100254', '102793', '102799', '102809', '100541', '100729', '100790', '100793', '100048', '103414', '102806', '100212', '100585', '100047''100010', '100042', '100041', '100350', '100014', '100071', '100002', '100245', '100470', '100005', '100259', '100019', '100597', '100383', '100384', '100260', '100012', '100601', '100603', '100198', '100006', '100626', '100032', '100013', '100206', '100579', '100035', '100322', '100555', '100339', '100693', '100011', '100113', '100074', '100001', '101690', '101700', '101703', '101705', '101745', '101752', '100826', '100341', '102697', '100733', '100862', '100535', '100538', '100208', '100572', '100004', '100222', '100317', '100325', '100026', '100018', '100133', '104302', '104308', '104311', '100016', '100082', '100434', '104312', '100435', '100007', '100094', '100095', '100030', '100598', '100027', '100807', '100262', '100591', '100199', '100263', '100241', '100346', '100594', '101648', '101673', '101777', '104314', '100441', '100475', '100491', '100578', '102747', '100213', '103099', '103102', '100008', '100151', '100754', '100478', '100334', '100553', '100249', '101696', '101760', '101780', '101763', '100743', '100181', '100165', '100216', '100088', '100091', '104956', '100210', '100596', '100627', '102964', '100034', '100400', '100703', '100707', '100806', '100352', '100834', '103479', '100211', '100581', '100370', '100381', '100372', '100735', '100062', '100121', '100238', '706233', '101994', '101996', '100590', '100577', '102203', '102205', '100050', '104813', '102208', '100239', '100769', '100254', '102793', '102799', '102809', '100541', '100729', '100790', '100793', '100048', '103414', '102806', '100212', '100585', '100047', '704498') OR category_id IN () OR category_id IN ('328','329') ORDER BY parent_block_order ASC, FIELD(a1_categories.category_parent, '1597', a1_categories.category_parent), a1_categories.category_order ASC, open_engine_count DESCcant select cats 1 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 ') OR category_id IN ('328','329') ORDER BY parent_block_order ASC, FIEL...' at line 12