Find state listed by lskin
SELECT p.frn_lskinid, s.thestate FROM lskinproperty p JOIN lskin_state s ON s.lskin_stateid = p.frn_lskin_stateid WHERE p.frn_lskinid IN ('lskin1','lskin2') ORDER BY frn_lskinid