36 $sSelect =
"select oxuser.oxid, oxuser.oxfname, oxuser.oxlname from oxuser ";
37 $sSelect .=
"left join oxuserbaskets on oxuserbaskets.oxuserid = oxuser.oxid ";
38 $sSelect .=
"where oxuserbaskets.oxid is not null and oxuserbaskets.oxtitle = 'wishlist' ";
39 $sSelect .=
"and oxuserbaskets.oxpublic = 1 ";
40 $sSelect .=
"and ( oxuser.oxusername like '%$sSearchStr%' or oxuser.oxlname like '%$sSearchStr%')";
41 $sSelect .=
"and ( select 1 from oxuserbasketitems where oxuserbasketitems.oxbasketid = oxuserbaskets.oxid limit 1)";