StoreDocumentTable::withProduct

static function withProduct(MainORMQueryQuery $query, $productId)
{
	$productId = (int)$productId;
	if ($productId <= 0)
	{
		return;
	}

	$tableName = StoreDocumentElementTable::getTableName();
	$query->whereExpr("
		(
			CASE WHEN EXISTS (
				SELECT ID
				FROM {$tableName}
				WHERE DOC_ID = %s
				AND ELEMENT_ID = {$productId}
			)
			THEN 1
			ELSE 0
			END
		) = 1
	", ['ID']);
}