ERROR: syntax error at or near "and" at character 307
Actually error is at character 618
-------------------------------------------------
/*=20
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 =3D atsd.test_suit_id
where atsd.test_group_id =3D 6204 and ats.suit_status_id =3D get_proper=
ty_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 =3D atsd.test_suit_id
left join akh_test_suit_type atst on atst.ID =3D ats.test_suit_type_ID
where atsd.test_group_id =3D ? and ats.suit_status_ID =3D get_property( 's=
uit_status', 'IN DEV' )
group by atsd.test_group_id, atst.value
-- */
