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', '100353', '100359', '100041', '100350', '100002', '100245', '100470', '100005', '100259', '100019', '100597', '100383', '100384', '100260', '100261', '100214', '100253', '100598', '100012', '100199', '100223', '100231', '100373', '100376', '100229', '100386', '100601', '100603', '100198', '100006', '100027', '100807', '100626', '100032', '100013', '100206', '100579', '100035', '100684', '100476', '100493', '100234', '100475', '100490', '100491', '100238', '100239', '100769', '100233', '100514', '100533', '100201', '100014', '100074', '100004', '100222', '100317', '100321', '100535', '100538', '100208', '100572', '100727', '100571', '100018', '100134', '100133', '104302', '104308', '104309', '100016', '100082', '100431', '100003', '100396', '100404', '104317', '104318', '100085', '100452', '100405', '104319', '100453', '100406', '104320', '100455', '104311', '100434', '104312', '100435', '100407', '104321', '100457', '100007', '100094', '100095', '100225', '100374', '100227', '100375', '100228', '100377', '100210', '100596', '100806', '100030', '100263', '100241', '100346', '104377', '100515', '100520', '100531', '102450', '100251', '100717', '100102', '100103', '100594', '100337', '100001', '101648', '101673', '101777', '100826', '104313', '100438', '104314', '100441', '100224', '100789', '100521', '100519', '100525', '100578', '102747', '100213', '103099', '103102', '100202', '100592', '100008', '100151', '100150', '100246', '100153', '102778', '100397', '100754', '100478', '100334', '100322', '100553', '100249', '100136', '100011', '100121', '100340', '100371', '100212', '100586', '100316', '100630', '100593', '101655', '100744', '100745', '100567', '100399', '100422', '100424', '100378', '100088', '100091', '104956', '100400', '100703', '100707', '100573', '100209', '100805', '100839', '104303', '104304', '100080', '100450', '100252', '100247', '100875', '104324', '100877', '100211', '100581', '100370', '100381', '100372', '100735', '100062', '706233', '101994', '101996', '100590', '100577', '102027', '104326', '102029', '102203', '102205', '100050', '104813', '102208', '102224', '102227', '100262', '100240', '100776', '100682', '100254', '102793', '102795', '100541', '100729', '100790', '100793', '102809', '100048', '103414', '102806', '102800', '102931', '100517', '100522', '100585', '100759', '100047''100010', '100353', '100359', '100041', '100350', '100002', '100245', '100470', '100005', '100259', '100019', '100597', '100383', '100384', '100260', '100261', '100214', '100253', '100598', '100012', '100199', '100223', '100231', '100373', '100376', '100229', '100386', '100601', '100603', '100198', '100006', '100027', '100807', '100626', '100032', '100013', '100206', '100579', '100035', '100684', '100476', '100493', '100234', '100475', '100490', '100491', '100238', '100239', '100769', '100233', '100514', '100533', '100201', '100014', '100074', '100004', '100222', '100317', '100321', '100535', '100538', '100208', '100572', '100727', '100571', '100018', '100134', '100133', '104302', '104308', '104309', '100016', '100082', '100431', '100003', '100396', '100404', '104317', '104318', '100085', '100452', '100405', '104319', '100453', '100406', '104320', '100455', '104311', '100434', '104312', '100435', '100407', '104321', '100457', '100007', '100094', '100095', '100225', '100374', '100227', '100375', '100228', '100377', '100210', '100596', '100806', '100030', '100263', '100241', '100346', '104377', '100515', '100520', '100531', '102450', '100251', '100717', '100102', '100103', '100594', '100337', '100001', '101648', '101673', '101777', '100826', '104313', '100438', '104314', '100441', '100224', '100789', '100521', '100519', '100525', '100578', '102747', '100213', '103099', '103102', '100202', '100592', '100008', '100151', '100150', '100246', '100153', '102778', '100397', '100754', '100478', '100334', '100322', '100553', '100249', '100136', '100011', '100121', '100340', '100371', '100212', '100586', '100316', '100630', '100593', '101655', '100744', '100745', '100567', '100399', '100422', '100424', '100378', '100088', '100091', '104956', '100400', '100703', '100707', '100573', '100209', '100805', '100839', '104303', '104304', '100080', '100450', '100252', '100247', '100875', '104324', '100877', '100211', '100581', '100370', '100381', '100372', '100735', '100062', '706233', '101994', '101996', '100590', '100577', '102027', '104326', '102029', '102203', '102205', '100050', '104813', '102208', '102224', '102227', '100262', '100240', '100776', '100682', '100254', '102793', '102795', '100541', '100729', '100790', '100793', '102809', '100048', '103414', '102806', '102800', '102931', '100517', '100522', '100585', '100759', '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