Пример #1
0
 public static function getUserSIDsByProductSID($productSID)
 {
     $sql_result = SJB_DB::query("SELECT DISTINCT users.sid  \n\t\t\tFROM users \n\t\t\tINNER JOIN contracts ON users.sid = contracts.user_sid \n\t\t\tINNER JOIN products ON products.sid = contracts.product_sid \n\t\t\tWHERE products.sid=?n \n\t\t\tGROUP BY users.sid", $productSID);
     return SJB_UserManager::_getUserSIDsFromRawSIDInfo($sql_result);
 }