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', '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', '100007', '100102', '100112', '100006', '100027', '100807', '100626', '100032', '100013', '100206', '100579', '100035', '100684', '100476', '100493', '100234', '100475', '100490', '100491', '100004', '100222', '100317', '100321', '100238', '100239', '100769', '100233', '100514', '100533', '100201', '100014', '100074', '100071', '100535', '100538', '100240', '100773', '100208', '100572', '100026', '100001', '101648', '101656', '101657', '101465', '101466', '100143', '100433', '100571', '100018', '100134', '100133', '104302', '104308', '104309', '100016', '100082', '100431', '104311', '100434', '104312', '100435', '100683', '100088', '100089', '100094', '100095', '100225', '100374', '100227', '100375', '100228', '100377', '101705', '101715', '101716', '101407', '101408', '101409', '100043', '100275', '100454', '100806', '100030', '100038', '102747', '100262', '100776', '100263', '100241', '100346', '100003', '100398', '100422', '100424', '104377', '100515', '100520', '100531', '102450', '100251', '100717', '100594', '101673', '101777', '100826', '104313', '100438', '104314', '100441', '100103', '100224', '100789', '100521', '100519', '100525', '100578', '100213', '103099', '103102', '100202', '100592', '100008', '100151', '100150', '100246', '100153', '100207', '100589', '100135', '100754', '100478', '100136', '100011', '100121', '100340', '100371', '100212', '100586', '100316', '100070', '100630', '100593', '100322', '100553', '101655', '100744', '100745', '100567', '100399', '100378', '100091', '104956', '100210', '100596', '100403', '103278', '100627', '102964', '100034', '100400', '100703', '100707', '100401', '100573', '100517', '100759', '100209', '100805', '100839', '104303', '104304', '100080', '100450', '100252', '100211', '100581', '100370', '100381', '100372', '100735', '100062', '706233', '101994', '101996', '100590', '100577', '102203', '102205', '100050', '104813', '102208', '102224', '102227', '100397', '100682', '100254', '102793', '102795', '100541', '100729', '100790', '100793', '102809', '100048', '103414', '102806', '100249', '102800', '102931', '100415', '100522', '100585', '100047''100010', '100042', '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', '100007', '100102', '100112', '100006', '100027', '100807', '100626', '100032', '100013', '100206', '100579', '100035', '100684', '100476', '100493', '100234', '100475', '100490', '100491', '100004', '100222', '100317', '100321', '100238', '100239', '100769', '100233', '100514', '100533', '100201', '100014', '100074', '100071', '100535', '100538', '100240', '100773', '100208', '100572', '100026', '100001', '101648', '101656', '101657', '101465', '101466', '100143', '100433', '100571', '100018', '100134', '100133', '104302', '104308', '104309', '100016', '100082', '100431', '104311', '100434', '104312', '100435', '100683', '100088', '100089', '100094', '100095', '100225', '100374', '100227', '100375', '100228', '100377', '101705', '101715', '101716', '101407', '101408', '101409', '100043', '100275', '100454', '100806', '100030', '100038', '102747', '100262', '100776', '100263', '100241', '100346', '100003', '100398', '100422', '100424', '104377', '100515', '100520', '100531', '102450', '100251', '100717', '100594', '101673', '101777', '100826', '104313', '100438', '104314', '100441', '100103', '100224', '100789', '100521', '100519', '100525', '100578', '100213', '103099', '103102', '100202', '100592', '100008', '100151', '100150', '100246', '100153', '100207', '100589', '100135', '100754', '100478', '100136', '100011', '100121', '100340', '100371', '100212', '100586', '100316', '100070', '100630', '100593', '100322', '100553', '101655', '100744', '100745', '100567', '100399', '100378', '100091', '104956', '100210', '100596', '100403', '103278', '100627', '102964', '100034', '100400', '100703', '100707', '100401', '100573', '100517', '100759', '100209', '100805', '100839', '104303', '104304', '100080', '100450', '100252', '100211', '100581', '100370', '100381', '100372', '100735', '100062', '706233', '101994', '101996', '100590', '100577', '102203', '102205', '100050', '104813', '102208', '102224', '102227', '100397', '100682', '100254', '102793', '102795', '100541', '100729', '100790', '100793', '102809', '100048', '103414', '102806', '100249', '102800', '102931', '100415', '100522', '100585', '100047', '704498', '100411') 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