Steps to reproduce the issue

use a published module and assign only selected menu-items (not "all" menu items)
use $modobj = JModuleHelper::getModule("your-module");

Expected result

$modobj should reflect module properties

Actual result

$modobj does not reflect module properties

System information (as much as possible)

Joomla Version 3.3.6

Additional comments

Causer is wrong sql (see title) at line 360 of ./libraries/cms/module/helper.php:
->where('(mm.menuid = ' . (int) $Itemid . ' OR mm.menuid <= 0)');
should be (fixed problem):
->where('(mm.menuid = ' . (int) $Itemid . ' OR mm.menuid = 0)');