ERROR: syntax error at or near "and" at character 307 Actually error is at character 618 ------------------------------------------------- /* DELETE FROM akh_test_suit_detail WHERE ID in ( select atsd.id as id1 from akh_test_suit_detail atsd left join akh_test_suit ats on ats.ID = atsd.test_suit_id where atsd.test_group_id = 6204 and ats.suit_status_id = get_property_id( 'suit_status', 'IN DEV' ) ) -- */
-- /* INSERT INTO akh_test_suit_detail ( test_suit_id, test_group_id ) select atst.value::integer, atsd.test_group_id as id2 from akh_test_suit_detail atsd left join akh_test_suit ats on ats.ID = atsd.test_suit_id left join akh_test_suit_type atst on atst.ID = ats.test_suit_type_ID where atsd.test_group_id = ? and ats.suit_status_ID = get_property( 'suit_status', 'IN DEV' ) group by atsd.test_group_id, atst.value -- */